Reset databases to dbo
-
A lot of wierd problems have been happening since my network admin rebuilt the servers and well some databases do not have owners and some have sa. I was wonderin if there was a way to set all databases to be owned by dbo?
Matt
-
You can execute sp_changedbowner in the db
-
EXEC sp_MSforeachdb @command1 = "PRINT '/*CHANGING ? OWNER TO SA*/'",
@command2 = "EXEC
..sp_changedbowner 'sa'"
Tim C.
//Will write code for food
Tim C //Will code for food -
Matt, dbo doesn't own databases, dbo is a special user in all databases that sysadmin logins map to. As Tim shows, set sa as owner of your databases by using sp_changedbowner
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
..sp_changedbowner 'sa'"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply