January 10, 2007 at 4:02 am
Is there a way where by I can change the owner of the model database??
January 10, 2007 at 5:00 am
why on earth would you want to do that?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 10, 2007 at 9:02 pm
I have a server where the owner of Model database is not SA but some other user. I don't know how it happened because I noticed it recently.
So I need to change it back to SA.
January 11, 2007 at 3:30 am
I've never had to change owner of model, I assume sp_changedbowner doesn't work?
IF not I guess if you follow the process for moving the model database then when you re-attach it you would set the user back to sa. see ms articles on moving system databases.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply