Brandon Petersen

I have to move databases between servers recently, doing a backup and restore. I had some issues arise from improper ownership of tables and store procedures in Microsoft SQL Server (MSSQL). I fixed the issue quickly through the following query:

sp_changeobjectowner ‘object’, ‘new_owner’

This entry was posted on Wednesday, April 25th, 2007 @ 2:16 pm on the category General.

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your site.