SQL Server Ownership Changes
I recently moved a SQL Server 2000 database from a server owned by a client to my test server. In the process, several objects retained as owner a user that was not in my server (and I did not want in my server). I've used the sp_changeobjectowner for single changes, but was not looking forward to having to do fifty objects one at a time.
After a quick Google, I found the this Microsoft Knowledge Base article (275312). It works like a charm.
So if you need to do a bunch of ownership changes in SQL Server 2000, check that out.
0 Comments:
Post a Comment
<< Home