Contents tagged with SQL

• XPath/XQuery SQL counting repeatable nodes in SQL Server 2008

  Tags: XML, SQL

  May 20 2008 1:33 PM

  0 Comments

  XML is represented in a field, vchr_Xml on table A, trying to count entities - can use xpath in the sql/xquery to get the count of repeatable nodes.

  select convert(int, … more

• Getting rid of annoying orphaned users on a SQL Server 2005 database

  Tags: SQL Server 2005, SQL

  Mar 5 2008 10:31 AM

  0 Comments

  A nice one of those microsoft errors this one!! 

  Trying to delete an old user on a database which i have restored, but there is a problem, it throws an error, 'Drop failed for User ABC' … more