sde Posted December 22, 2003 Posted December 22, 2003 can anyone advise me how to change the owner of a table in mssql? i like to sort by 'owner' so i can see all my tables on top of all the default tables mssql creates. there are a couple of the tables i made which show up as owner 'dbo' and not the user i created them with. any insight would be greatly appreciated. thanks Quote codenewbie
Administrators PlausiblyDamp Posted December 22, 2003 Administrators Posted December 22, 2003 sp_changeobjectowner object, new owner Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.