Also, the database is made read-only after so no changes are made to the database but needs to be accessible for reference purposes (which is why I needed to move...

Hello Erland, the couple of backups applies to full or bulk-logged recovery models which is why I changed the recovery model to simple so a single checkpoint will be enough...

Fixed the problem. I'm not too confident what I did is the best way to resolve the problem but since I saved snapshots of the DB, server and what I'm...

Thanks, Patrick. I cross-posted this question on the TSQL forum and geoff5 had a solution without pivot and only one CTE:

http://www.sqlservercentral.com/Forums/Topic1446659-392-1.aspx

Thanks, geoff5! Your solution's much shorter and easier to understand.

Thanks, Lowell, I was able to make it work using your linked server solution. I dug around and found a thread in the SQL 2005 forum that discussed how to...

Thanks for the quick reply Lowell. I don't think xp_logininfo works as the accounts I'm creating don't have access to the SQL server. For AD purposes, the accounts are just...