Adding Items Using DataBinding from TreeView to ListBox WPF

Hi,

I want to add the selected item from the TreeView to the ListBox control using DataBinding (If it can work with Databinding).

 <TreeView HorizontalAlignment="Left" Margin="30,32,0,83" Name="treeView1" Width="133" >



      </TreeView>
      <ListBox  Margin="208,36,93,0" Name="listBox1" Height="196" VerticalAlignment="Top">       


      </ListBox>

TreeView is populated from the code behind page with some dummy data.

From stackoverflow azamsharp

• I'm pretty sure it is possible, since WPF is really flexible with data binding, but I haven't done that specific scenario yet.

  I've been following a WPF Databinding FAQ from the MSDN blogs as of late and it provides a lot of insights that might help.

  From Dillie-O

• You can bind to an element using ElementName, so if you wanted to bind the selected tree item to the ItemsSource of a ListBox:

  ItemsSource="{Binding SelectedItem, ElementName=treeView1}"
  

  From Dylan

Ajax XMLHttpRequest object limit

Is there a security limit to the number of Ajax XMLHttpRequest objects you can create on a single page? If so, does this vary from one browser to another?

From stackoverflow Keith Maurino

• I don't think so, but there's a limit of two simultaneous HTTP connections per domain per client (you can override this in Firefox, but practically no one does so).

  Marcel Korpel : Nowadays, this limit is higher, e.g. on my current Firefox (3.6.3/Linux) the default number of simultaneous HTTP connections is 6. You can test it with [this little test case](http://www.spasche.net/files/parallel_connections/).
  From Kevin

• Yes, as Kevin says, HTTP/1.1 specifications say "A single-user client should not maintain more than 2 connections with any server or proxy."

  From fluteflute

• I've found it easier to pool and reuse XMLHTTPRequest objects instead of creating new ones...

  Marcel Korpel : Agreed, but that doesn't work if you want to have multiple simultaneous requests.
  From FlySwat

Linq to SQL - Accessing System Databases/Tables?

Right now I have an SSIS package that runs every morning and gives me a report on the number of packages that failed or succeeded from the day before. The information for these packages is contained partly within the sysjobs table (a system table) within the msdb database (a system database) in SQL Server 2005.

When trying to move the package to a C# executable (mostly to gain better formatting over the email that gets sent out), I wasn't able to find a way to create a dbml file that allowed me to access these tables through Linq. I tried to look for any properties that would make these tables visible, but I haven't had much luck.

Does anyone know if this is possible with Linq to SQL?

From stackoverflow jerhinesmith

• It may not be available in the designer, but why not just add it to the DBML file itself?

  From Danimal

• If you're in Server Explorer, you can make them visible this way:

  • Create a connection to the server you want.
  • Right-click the server and choose Change View > Object Type.
  • You should now see System Tables and User Tables. You should see sysjobs there, and you can easily drag it onto a .dbml surface.
  jerhinesmith : Perfect. Thanks!
  From Kyralessa

Best tool to monitor network connection bandwidth

I'm looking for a very simple tool to monitor the bandwidth of all my applications. No need for extra features like traffic spying, I'm just interested by bandwidth.

I already know Wireshark (which is great), but what I'm looking for is more something like TcpView (great tool from Sysinternals) with current bandwidth indication.

PS: I'm interested by Windows tools only

From stackoverflow Steve Gury

• Try NetLimiter, which is great for that and also allows you to limit bandwidth usage so that you can test your app in reduced bandwidth scenarios.

  Steve Gury : Thanks, after using it for a couple of hours, I can say that's a great soft, definitely!
  From Alvaro Rodriguez

Could not load type 'XXX.Global'

Migrating a project from ASP.net 1.1 to ASP.net 2.0 and I keep hitting this error.

I don't actually need Global because I am not adding anything to it, but after I remove it I get more errors.

From stackoverflow Brian G

• There are a few things you can try with this, seems to happen alot and the solution varies for everyone it seems.

  If you are still using the IIS virtual directory make sure its pointed to the correct directory and also check the asp.net version it is set to, make sure it is set to asp.net 2

  Clear out your bin/debug/obj all of them. Do a clean solution and then a Build Solution.

  Check your project file in a text editor and make sure where its looking for the global file is correct, sometimes it doesnt change the directory.

  remove the global from the solution and add it back after saving and closing. make sure all the script tags in the aspx file point to the correct one after.

  You can try running the convert to web application tool, that redoes all of the code and project files.

  Make sure you close VS after you try them.

  Those are some things i know to try. Hope one of them works for you.

  Rob Stevenson-Leggett : Did any of these work for you?

  pete blair : yeah i have used those over time and one of them would usually resolve the issue.
  From pete blair

• I've found that it happens when the Global.asax.(vb|cs) wasn't converted to a partial class properly.

  Quickest solution is to surround the class name 'Global' with [square brackets] like so (in VB.Net):

  Public Class [Global]
      Inherits System.Web.HttpApplication
      ...
  

  From Mark Glorie

• I had this same problem installing my app to a server. It ended up being the installer project, it wasn't installing all the files needed to run the web app. I tried to figure out where it was broken but in the end I had to revert the project to the previous version to fix it. Hope this helps someone...

  From campo

How do I transfer my Google chrome profile to a new PC?

Now that I have Google Chrome all set up, I got me a new laptop. Does anyone have any idea how to transfer my settings, cookies, favorites, etc? I checked documents and settings\me\application data, and found nothing.

Edit: Hrmm, this isn't really a programming question, is it? Should I delete it?

From stackoverflow Danimal

• This link should help you out - basically:

  • On XP - C:\Documents and Settings\<User Name>\Local Settings\Application Data\Google\Chrome\User Data
  • On Vista - C:\Users\<User Name>\AppData\Local\Google\Chrome\User Data
  Prakash : you got it! +1 :)

  ConroyP : good timing on this one, have been looking at this myself only this morning!
  From ConroyP

• Its all there in Local Settings\Application Data\Google\Chrome

  From Prakash

Best way to draw text with OpenGL and Cocoa?

Does anyone know an easy way to draw arbitrary text in a Cocoa NSOpenGLView? I have a couple of constraints.

• The text on screen may change from frame to frame (for example, a framerate display in the corner)
• I would like to be able to select any font installed on the system at any size

From stackoverflow Jay Conrod

• Have you taken a look at the Cocoa OpenGL sample code? It includes "a texture class for strings, showing how to use an NSImage to write a string into and then texture from for high quality font rendering."

  From Hagelin

SharePoint: Using RichHTML field type in a custom content type

Hello,

I'd like to use the field type RichHTML in a custom content type that I'm making. However, I think that the RichHTML type comes with MOSS Publishing so I'm unsure how to add it to my content type. Right now I've tried with this:

<Field ID="{7F55A8F0-4555-46BC-B24C-222240B862AF}" Type="RichHTML" Name="NewsBodyField" DisplayName="News Body" StaticName="NewsBodyField" Hidden="False" Required="True" Sealed="False" />

<Field ID="{7F55A8F0-4555-46BC-B24C-222240B862AF}" Type="RichHtmlField" Name="NewsBodyField" DisplayName="News Body" StaticName="NewsBodyField" Hidden="False" Required="True" Sealed="False" />

I know that when I want to access this custom field using a CQWP, I can export it and add it to my CommonViews using 'RichHTML', however that doesn't work here.

Any help regarding how to add a Rich Html Field to a custom content type would be much appreciated.

From stackoverflow $pageUsers[$entry.posts[0].author].name

• I figured it out myself. The type you're looking for is "HTML" not RichHTML.

  From $pageUsers[$post.author].name

How to control IIS 5.1 from command line?

Hey there,

I found some informations about controlling IIS 5.1 from command line via adsutil.vbs (http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/d3df4bc9-0954-459a-b5e6-7a8bc462960c.mspx?mfr=true). The utility is available at c:\InetPub\AdminScripts.

The utility throw only errors like the following: ErrNumber: -2147463164 (0x80005004) Error Trying To GET the Schema of the property: IIS://localhost/Schema/ROOT

Can you tell me, how to check if there exists a virtual directory and create it, if it does not exist?

Thanks Thomas

From stackoverflow Thomas

• Hope this helps you.

  http://www.codeproject.com/KB/system/commandlineweb.aspx

  From Codeslayer

• I could not comment your post, so I have to write a new message. I was able to use the script CreateWebDir.vbs from your link and use it to create/update my virtual directory with only one call:

  CreateWebDir.vbs DirName Path 80

  If the virtual directory already exists, it changes the path and that's exactly, what I need. Thank you!

  From Thomas

Standard way to merge Entities in LlblGenPro

I start with an entity A with primary key A1, it has child collections B and C, but they are empty, because I haven't prefetched them. I now get a new occurrence of A (A prime) with primary key A1 with the child collections B and C filled.

What is a good way to get the A and A prime to be the same object and to get A collections of B and C filled?

From stackoverflow automatic

• Once you, have 2 separate objects in memory and you have references to both of them the only way to merge them is to change all references to point to one of the objects, which might be impossible. However there's something you can do not to arrive in this situation you can use a SD.LLBLGen.Pro.ORMSupportClasses.Context class which you can attach to an adapter and which acts as a caching layer and when entities are loaded it returns the same object for a unique entity, basically it does't let you duplicate entities in memory and always returns the reference to a already loaded entity.

  From Pop Catalin

How to efficiently SQL select newest entries from a MySQL database?

I have a database containing stock price history. I want to select most recent prices for every stock that is listed. I know PostreSQL has a DISTINCT ON statement that would suit ideally here.

Table columns are name, closingPrice and date; name and date together form a unique index.

The easiest (and very uneffective) way is

SELECT * FROM stockPrices s
WHERE s.date =
(SELECT MAX(date) FROM stockPrices si WHERE si.name = s.name);

Much better approach I found is

SELECT * FROM stockPrices s JOIN
(SELECT name, MAX(date) AS date
FROM stockPrices si GROUP BY name) lastEntry
ON s.name = lastEntry.name AND s.date = lastEntry.date;

What would be an efficient way to do this? What indexes should I create?

duplicate of:
http://stackoverflow.com/questions/49404/sql-query-to-get-latest-price

From stackoverflow skolima

• See similar post

  skolima : I fail at search.
  From Galwegian

• I think that your second approach is very efficient. What's its problem?

  You have to add indexes to name and date.

  Mike Woodhouse : Well, you have to add an index if performance requires it. If it's ten stocks and a year's daily data, I wouldn't be concerned: MySQL is relatively good at table scanning.

  Vinko Vrsalovic : If he had few data he wouldn't be asking for an efficient way to do this, no? Even the first, obvious approach would be enough.
  From Vinko Vrsalovic

How to properly link your a custom css file in sharepoint

I've created a custom list, and made some changes to the way the CQWP renders it on a page by modifying ItemStyle.xsl. However, I'd like to use some custom css classes and therefore I'd like to link to my own custom .css file from the head tag of the pages containing this CQWP.

So my question is, where to do put my .css file and how do I link it properly to a page containing the CQWPs. Please have in mind that I'm making a solution that should be deployed on multi sharepoint installations.

Thanks.

From stackoverflow $pageUsers[$entry.posts[0].author].name

• Consider uploading them to "Style Library" in the root of the site collection.

  If you don't have a "Style Library" at the root, consider making one -- it's just a document library.

  Make sure the permissions are set correctly so everyone who needs to read it can.

  You can reference them using "/Style%20Library/my.css" but this won't work on site collections that don't live at the root of the domain.

  From Hafthor

• Alright, that makes sense. But how to I actually link to them in a proper way. Preferably one that works when deploying the solution. Perhaps some magic when you activate a feature, or something like that.

  From $pageUsers[$post.author].name

• The microsoft official way is just to copy them into the relevant folders (as seen by downloading their template packs). However, you could also create your own site definition and add the items to the correct libraries and lists in the same way that the master pages are added.

  If you are going to deploy CSS and Master Pages through features remember you will have to activate your the publishing infrastructure on the site collection and the publishing feature on the site.

  To deploy a master page/page layout as a feature you should follow the steps at the site below, you can use the "fileurl" element to specify your CSS and place it into the correct folder (style library, for example): http://www.sharepointnutsandbolts.com/2007/04/deploying-master-pages-and-page-layouts.html

  From Mauro

Why is the 'Resource Pool' not supported on the current platform?

What could be the possible causes for the following exception?

System.PlatformNotSupportedException: 'ResourcePool' is not supported on the current platform.
   at System.EnterpriseServices.Platform.Assert(Boolean fSuccess, String function)
   at System.EnterpriseServices.Platform.Assert(Version platform, String function)
   at System.EnterpriseServices.ResourcePool..ctor(TransactionEndDelegate cb)
   at System.Data.SqlClient.ConnectionPool..ctor(DefaultPoolControl ctrl)
   at System.Data.SqlClient.PoolManager.FindOrCreatePool(DefaultPoolControl ctrl)
   at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
   at System.Data.SqlClient.SqlConnection.Open()

The platform is Windows 2003 Server SP2. The same code has been tested on Windows XP SP2 without any problems. However, it would be interesting to know what reasons cause this exception regardless of the platform.

From stackoverflow Manga Lee

• I've poked at the sources using Reflector and I can't seem to find any call to Platform.Assert in the static constructor of ResourcePool.

  Is the Windows 2003 server 64bit? That may be the problem.

  csgero : You have to load System.EnterpriseServices in Reflector. The constructor of ResourcePool contains the following line: Platform.Assert(Platform.W2K, "ResourcePool"); This does not answer the question, but at least we have the source of the exception.
  From Omer van Kloeten

How would you go about for switching a site from Prototype to jQuery

I have written a site in Prototype but want to switch to jQuery. Any ideas on how best make the switch?

From stackoverflow minty

• Personally, I like to take things in steps, so I would start by using both, like this:

  jQuery.noConflict();
  
  // Put all your code in your document ready area
  jQuery(document).ready(function($){
    // Do jQuery stuff using $
    $("div").hide();
  });
  
  // Use Prototype with $(...), etc.
  $('someid').hide();
  

  That way you don't have to convert all your old code at once, but can start using jquery on new stuff, and migrate your old Prototype code when ever it's convenient. I don't know the size of your project, so I can't say whether or not this applies to you, but Spolsky had a great article about "The big rewrite" and why it's such a bad idea in Things you should never do, Part 1. It's well worth a read!

  For more on using jquery with Prototype, see Using jQuery with other libraries in the jquery docs.

  thomasrutter : +1 I also think that article by Spolsky is a good one. And nifty use of .ready(function($){}), using $ as the argument name.
  From Erlend Halvorsen

SQL Server Freetext match - how do I sort by relevance

Is it possible to order results in SQL Server 2005 by the relevance of a freetext match? In MySQL you can use the (roughly equivalent) MATCH function in the ORDER BY section, but I haven't found any equivalence in SQL Server.

From the MySQL docs:

For each row in the table, MATCH() returns a relevance value; that is, a similarity measure between the search string and the text in that row in the columns named in the MATCH() list.

So for example you could order by the number of votes, then this relevance, and finally by a creation date. Is this something that can be done, or am I stuck with just returning the matching values and not having this ordering ability?

From stackoverflow Cebjyre

• If you are using FREETEXTTABLE then it returns a column name Rank, so order by Rank should work. I don't know if other freetext search methods are also returning this value or not. You can have a try.

  From Biri

• Thanks Biri,

  I've refactored the query to use FREETEXTTABLE rather than just FREETEXT - with a bit of hassle until I worked out that KEY is a reserved word and needs to be escaped, and all seems good.

  From Cebjyre

• Both FREETEXTTABLE and CONTAINSTABLE will return the [RANK] column, but make sure you are using either the correct variation or union both of them to get all appropriate results.

  From Josef

How do I enable external access to MySQL Server?

How do I enable external access to MySQL Server? I can connect locally but I cannot connect from another box on the network.

I just tried

grant all privileges on *.* to root@'%' identified by '*****' with grant option;

And restarted MySQL Server with no success.

From stackoverflow Nick Stinemates

• You probably have to edit the configuration file (usually my.cnf) to listen in the external interface instead of on localhost only.

  change the bind-address parameter to your machine's IP address.

  If this is an old MySQL installation, you should comment out the skip-networking parameter.

  Afterwards, restart MySQL and you'll be set

  From Vinko Vrsalovic

• Command and syntax looks fine. Have you checked the server is listening on an interface other than 127.0.0.1? By default Im pretty sure it only listens on the localhost address (127.0.0.1)

  From Craig

When building a Handler, should it be .ashx or .axd?

Say I'm building an ASP.Net class that inherits from IHttpHandler, should I wire this up to a URL ending in .ashx, or should I use the .axd extension?

Does it matter as long as there's no naming conflict?

From stackoverflow AndrewDotHay

• Ahh.. ScottGu says it doesn't matter, but .ashx is slightly better because there's less chance of a conflict with things like trace.axd and others. That's why the flag went up in my head that .ashx might be better.

  http://forums.asp.net/t/964074.aspx

  From AndrewDotHay

• Out in "the wild", .ashx are definitely the most popular extension.

  From Frank Krueger

Managed OleDB provider written in C#

An OleDB provider is a binary implementing COM interfaces provided by Microsoft. From that it seems to be possible to create a provider using C#. Is that correct? Is there a sample demonstrating that? If not, would you discourage me from doing that? I see that there are multiple unmanaged samples but I can't find any managed.

From stackoverflow David Pokluda

• It's way over my head... but here is an interesting Dino Esposito article on the subject at a high level:

  http://msdn.microsoft.com/en-us/library/ms810268.aspx

  From rp

• I am not sure I really understand your question?! There already is a managed OleDBProvider?!

  using System.Data.OleDb;
  

  I would certainly discourage writing a provider that exists and works absolutely fine! :)

  But in answer to your first question, you can of course create your own. The Data Provider Roadmap may be a good place to start for an overview and links to samples etc.

  From Rob Cooper

How do you create a shortcut to a directory so that it opens in explorer

Better yet, how can I make My Computer always open in Explorer as well?

I usually make a shortcut to my programming directories on my quick launch bar, but I'd love for them to open in Explorer.

From stackoverflow FlySwat

• Have you considered the win+e hotkey? It isn't quite what you want, but might be close enough.

  From Rob Rolnick

• explorer -d c:\path

  From harpo

• This is a good reference: http://support.microsoft.com/kb/130510

  i.e.:
  explorer /e,%HOMEDRIVE%%HOMEPATH%
  

  From csjohnst

• I use explorer /e,c:\path.

  @harpo

  explorer -d c:\path does not work for me (WinXP sp3).

  J.F. Sebastian : Replace `@[harpo]` by `@harpo`

  Blorgbeard : hey, it works! thanks
  From Blorgbeard

Should we stop using Zend WinEnabler?

Our system uses Zend WinEnabler. Do you use it? Is it obsolete? Should we stop using it? Is it known to cause handle/memory leaks?

Here is an (old) introduction to it: "PHP Creators Unveil New Product that Makes PHP Truly Viable for Windows Environments" http://personalweb.about.com/b/2004/03/29/zend-announces-winenabler-enabling-php-for-windows-environments.htm

Thanks in advance to all respondents.

From stackoverflow Mark

• Since Zend appears to not be selling it anymore and all its functionality is available for free (through FastCGI), I would say so. Look at the Zend Core (installing Zend Core) if you really want to run PHP on Windows. But really, you should be asking yourself why you are running PHP on Windows at all (we used to do it, and the headaches where enormous, especially since nobody else was doing it).

  From Kris Erickson

How could I get my SVN-only host to pull from a git repository?

I'd really like to get our host to pull from our Git repository instead of uploading files manually, but it doesn't have Git installed.

So is there a way to trick Subversion (which they do have) into checking out a Git repository?

I think I already know the answer, namely bug my host to add Git and live with it until they do, but I thought I would ask anyway.

From stackoverflow Peter Coulton

• This page should provide a workaround for your problem.

  http://code.google.com/p/support/wiki/ImportingFromGit

  Basically, you create a read-only clone of your Git repository in the SVN repository format, exporting updates as you go. An SVN hook could be written that fires after each update to copy the new files where you need them.

  From KeithL

Can you bind a DataTrigger to an Attached Property?

In WPF, is it possible for a DataTrigger to bind to an attached property?

I essentially want to use a converter on an attached property to provide a style when a particular validation rule has been broken. I am using markup like the following:

<DataTrigger Binding="{Binding Path=Validation.Errors, 
                       RelativeSource={RelativeSource Self}, 
                       Converter={StaticResource RequiredToBoolConverter}}" 
                       Value="True">
  <Setter Property="Background" Value="LightGreen" />
</DataTrigger>

However, when this runs, I get the following:

System.Windows.Data Error: 39 : BindingExpression path error: 'Validation' property not found on 'object' ''TextBox' (Name='')'. BindingExpression:Path=Validation.Errors; DataItem='TextBox' (Name=''); target element is 'TextBox' (Name=''); target property is 'NoTarget' (type 'Object')

If I change my DataTrigger binding path to "Text", I do not get the databinding error (but of course it does not provide the behaviour I am seeking).

From stackoverflow Brad Leach

• You need to wrap the property in parentheses:

  <DataTrigger Binding="{Binding Path=(Validation.Errors),...
  

  HTH, Kent

  emddudley : This is documented on MSDN at http://msdn.microsoft.com/en-us/library/ms752300.aspx#Path_Syntax
  From Kent Boogaart

HelpInsight documentation in Delphi 2007

I am using D2007 and am trying to document my source code, using the HelpInsight feature (provided since D2005). I am mainly interested in getting the HelpInsight tool-tips working. From various Web-surfing and experimentation I have found the following:

1. Using the triple slash (///) comment style works more often than the other documented comment styles. i.e.: {*! comment *} and {! comment }
2. The comments must precede the declaration that they are for. For most cases this will mean placing them in the interface section of the code. (The obvious exception is for types and functions that are not accessible from outside the current unit and are therefore declared in the implementation block.)
3. The first comment cannot be for a function. (i.e. it must be for a type - or at least it appears the parser must have seen the "type" keyword before the HelpInsight feature works)

Despite following these "rules", sometimes the Help-insight just doesn't find the comments I've written. One file does not produce the correct HelpInsight tool-tips, but if I include this file in a different dummy project, it works properly.

Does anyone have any other pointers / tricks for getting HelpInsight to work?

From stackoverflow Andrew

• I have discovered another caveat (which in my case was what was "wrong")

  It appears that the unit with the HelpInsight comments must be explicitly added to the project. It is not sufficient to simply have the unit in a path that is searched when compiling the project.

  In other words, the unit must be included in the Project's .dpr / .dproj file. (Using the Project | "Add to Project" menu option)

  From Andrew

• Looks like you have collected most of the useful information already. Thanks!

  From Jim McKeeth

How do I enable open id on a Java Webapp?

Is there a simple jar that I can just drop in a web app with simple configuration to allow people to log in my app and be seen as JASS user?

I am not looking just for a library that implement the protocol, but a complete solution for simple solution integration.

From stackoverflow $pageUsers[$entry.posts[0].author].name

• this may be useful:

  http://code.google.com/p/openid4java

  From John Boker

• or pick another option from: http://wiki.openid.net/Libraries they are:

  • openid4java
  • WSO OpenID Library
  • joid
  • NetMesh InfoGrid LID
  From dlamblin

Embed asp page without iframe

I want to embed an .asp page on an html page. I cannot use an iframe. I tried:

<object width="100%" height="1500" type="text/html" data="url.asp">
alt : <a href="url.asp">url</a>
</object>"

works great in ff but not ie7. Any ideas? Is it possible to use the object tag to embed .asp pages for IE or does it only work in ff?

From stackoverflow mrjrdnthms

• You might be able to fake it using javascript. You could either use AJAX to load the page, then insert the HTML, or load "url.asp" in a hidden iframe and copy the HTML from there.

  One downside (or maybe this is what you want) is that the pages aren't completely independent, so CSS rules from the outer page will affect the embedded page.

  From Matthew Crumley

• I've solved it in the past using Javascript and XMLHttp. It can get a bit hacky depending on the circumstances. In particular, you have to watch out for the inner page failing and how it affects/downgrades the outer one (hopefully you can keep it downgrading elegantly).

  Search for XMLHttp (or check this great tutorial) and request the "child" page from the outer one, rendering the HTML you need. Preferably you can get just the specific data you need and process it in Javascript.

  From Pedro

• Well, after searching around and testing I don't think it is possible. It looks to me like IE does not allow the object tag access to a resource that is not on the same domain as the parent. It would have worked for me if the content I was trying to pull in was on same domain but it wasn't. If anyone could confirm my interpretation of this it would be appreciated.

  From mrjrdnthms

In SQL Server, how do I identify *all* dependencies for a specific table using system tables/views?

I am writing a DDL script to drop a number of tables but need to identify all dependencies for those tables first. Those dependencies include foreign key constraints, stored procedures, views, etc. Preferably, I want to programmatically script out dropping those dependencies using the system tables/views before dropping the dependent table.

From stackoverflow Ray Vega

• You can use the sp_depends stored procedure to do this:

  USE AdventureWorks GO EXEC sp_depends @objname = N'Sales.Customer' ;

  http://msdn.microsoft.com/en-us/library/ms189487(SQL.90).aspx

  From Almond

• sp_depends is not reliable see: Do you depend on sp_depends (no pun intended)

  From SQLMenace

• This is extremely messy to write from scratch. Have you considered a 3rd party tool like Red-Gate SQL Dependency Tracker?

  From Eric

• you could always search through the syscomments table....that might take a while though...

  From Mauro

• Could you reference sysreferences?

  select 'if exists (select name from sysobjects where name = '''+c.name+''') '
  +' alter table ' + t.name +' drop constraint '+ c.name 
   from sysreferences sbr, sysobjects c, sysobjects t, sysobjects r
   where c.id = constrid 
    and t.id = tableid 
    and reftabid = r.id
    and r.name = 'my_table'
  

  That will generate a whole lot of conditional drop constraint calls. Should work.

  From glasnt

How to easily edit SQL XML column in SQL Management Studio

I have a table with an XML column. This column is storing some values I keep for configuring my application. I created it to have a more flexible schema. I can't find a way to update this column directly from the table view in SQL Management Studio. Other (INT or Varchar for example) columns are editable. I know I can write an UPDATE statement or create some code to update it. But I'm looking for something more flexible that will let power users edit the XML directly.

Any ideas?

Reiterating again: Please don't answer I can write an application. I know that, And that is exactly what I'm trying to avoid.

From stackoverflow Ron Harlev

• I do not think you can use the Management Studio GUI to update XML-columns without writing the UPDATE-command yourself.

  One way you could let users update xml-data is to write a simple .net based program (winforms or asp.net) and then select/update the data from there. This way you can also sanitize the data and easily validate it against any given schema before inserting/updating the information.

  From Espo

• I wound up writing a .net c# UI to deal with the xml data. Using xsl for display and an xml schema helped display the xml nicely and maintain it's integrity.

  edit: Also c# contains the xmldocument class that simplifies reading/writing the data.

  From Paulj

• I'm a bit fuzzy in this are but could you not use the OPENXML method to shred the XML into relational format then save it back in XML once the user has finished?

  Like others have said I think it might be easier to write a small app to do it!

  Ron Harlev : I know I can write an app. I mentioned it in the question :) Editing values in the table view directly has its benefits. If I can do it for numbers and strings, I would like to do it for XML too.
  From Almond

• sql server management studio is missing this feature.

  I can see Homer Simpson as the Microsoft project manager banging his head with the palm of his hand: "Duh!"

  Of course, we want to edit xml columns.

  From Todd

What are the best RSS feeds for software project/program managers?

ENG or RUS Language only.

From stackoverflow Omega

• In my opinion, Jurgen Appelo's site is awesome.

  http://www.noop.nl/

  http://feeds.feedburner.com/noop

  From Ryan Lanciaux

• I love Johanna Rothman's blog Managing Product Development.

  From Mark Biek

• From a management standpoint, there are two that I love (not IT specific):

  1. Rands in Repose -- management observations
  2. Manager Tools -- a blog and a series of great podcasts on managing people
  From Guy Starbuck

• Two that I read:

  How to be a Good Product Manager
  The Cranky Product Manager

  From DGentry