Discussions

The normal way to do it would be to copy the UNION of the table with itself (to remove duplicates) to a temp table, truncate the table, then move the data back.

XML will be slower, harder to query and far harder to write reports against. There are situations where you'd use an xml column, but this really isn't one of them!

The number of times I've seen this question come up! Seriously, any design that *requires* this is a poor design. What are you doing with the list of values that you can't do in a transaction with multiple sp calls?

Register your extensions using the [SoapExtensionAttribute] syntax on each web method, rather than registering them in your web.config

I run TreeWalk DNS on my windows XP machine as both a caching DNS server for personal use and also as an unpublished master for my domains. It's basically a full version of BIND but with all of the bugs and security flaws fixed. Being BIND it doesn't have a fancy GUI to configure it, but you get all of the power of an enterprise level DNS server. You can find it at http://www.ntcanuck.com/

If you've got WINS running you should be able to see a user object in the WINS management console. Not sure how it works with a user logged on to multiple machines though.

But when I'm in a web browser I expect the default protocol to be http:// not "randomly search my computer for a shortcut with this name"

You're definitely approaching the problem in the wrong manner if you think you need to use an array in SQL. Perhaps you can explain exactly what it is you need to do and we'll be able to suggest a better approach.

Team Foundation Server is licensed separately from the MSDN subscriptions. If you have one of the Visual Studio Team Edition For x (or Team Suite) licenses, you will get Team Foundation Server *Workgroup Edition*. No-one gets *Standard Edition* as part of MSDN - you have to purchase it separately.

Just load the XML into an XmlDocument object then write the document using an XmlTextWriter with the indent and whitespace settings you require.