Here’s a handy little script which tells you what version, service pack and edition of SQL Server you’re running. It’s best to display results as “Text” rather than the “Grid”.
Xml data stored using the SQL Server 2005 xml data type can be exported a number of ways and you can obviously write a managed stored procedure to do it. However for a quick, one off, type approach you can use the BCP command. The downside of this is that, given the command above you’ll get … Continue reading Export SQL Server 2005 Xml Column Data to Xml File