This Blog is about MSSQL server 2000/2005 and 2008
Tuesday, January 13, 2009
Change all db owners to 'sa'
sp_helpdb go EXEC master..sp_MSForEachDB '
if(''?'' not in (''master'',''msdb'',''tempdb'',''model'')) begin print ''use ''+''?'' print ''go'' print ''exec sp_changedbowner sa'' print ''go'' end ' go
No comments:
Post a Comment