Home Forums SQL Server 2008 SQL Server 2008 - General Changing db owner script RE: Changing db owner script
Robert Klimes
SSCoach
Points: 17865
More actions
February 9, 2011 at 11:44 am
#1284732
You could try creating a central management server(http://msdn.microsoft.com/en-us/library/bb934126.aspx) an then use sp_msforeachdb 'USE [?]; EXEC dbo.sp_changedbowner @loginame = ''sa'', @map = false'
sp_msforeachdb 'USE [?]; EXEC dbo.sp_changedbowner @loginame = ''sa'', @map = false'
Bob-----------------------------------------------------------------------------How to post to get the best help[/url]