After restoring a database from a remote server backup, the “Login name” is often disassociated. Read More
Tag Archives: SQL Server 2005
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