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 » ]