Sql Server 2005 “Login name” is blank after restoring from backup

After restoring a database from a remote server backup, the “Login name” is often disassociated. [ Read more » ]

Preserving Whitespace FOR OPENXML

Using Microsoft SQL Server 2005, when you read xml data using FOR OPENXML, whitespace characters are replaced with a single space. After digging through the internet for half an hour, I found a couple options. [ Read more » ]