Monday, 4 May 2009

change object owners

This script changes the owner of an object in the current database.
Note: A database user can't be deleted if it owns objects.

EXEC sp_changeobjectowner '.', 'dbo'

No comments:

Post a Comment

Note: only a member of this blog may post a comment.