April 3, 2008 at 7:02 am
Running SQL 2000, can you change the DB Owner from dbo to whatever you want through Enterprise Manager, or do you HAVE to run a script? If you can do it through Enterprise Manager, please tell me how, because I can't find it anywhere what-so-ever! Thanks in advance.
-J
April 3, 2008 at 7:27 am
jason.stinson (4/3/2008)
Running SQL 2000, can you change the DB Owner from dbo to whatever you want through Enterprise Manager, or do you HAVE to run a script? If you can do it through Enterprise Manager, please tell me how, because I can't find it anywhere what-so-ever! Thanks in advance.-J
You have to use sp_changedbowner
Regards,
Andras
April 3, 2008 at 7:27 am
I can't find a way to do it in EM but you can use "sp_changedbowner". Check out BOL. Also, watch the forum that you're posting to. This is SQL 2005 and you're asking about SQL 2000. Everyone will try to help but you'll get more accurate responses in the proper forums.;)
-- You can't be late until you show up.
April 3, 2008 at 7:46 am
jason.stinson (4/3/2008)
Running SQL 2000, can you change the DB Owner from dbo to whatever you want through Enterprise Manager, or do you HAVE to run a script?
Just to clarify the DB owner will always be dbo and you cannot change this fact. You can however change the user mapped to dbo using sp_changedbowner. Additionally you cannot map dbo to someone whom already has access via another database user account either, so be aware of that.
April 3, 2008 at 8:07 am
This is feature in Management studio 2005 and was not in Enterprise Manager of Sql Server 2000
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply