I tend to have to move one SQL database to an other SQL server. With this I alway forget about the table owners so I have to use the sp.changeobjectowner.

In 2000 it seemed fairley straight forward and I was able to do it,  but in SQL 2005 I was struggleing, but really it is easy.

sp_changeobjectowner '[oldowner].[tabe1]', 'newowner'
go

Posted in Uncategorized
No Comments Yet Posted by charlie