Robert klimes (2/9/2011)
You could try creating a central management server(http://msdn.microsoft.com/en-us/library/bb934126.aspx) an then usesp_msforeachdb 'USE [?]; EXEC dbo.sp_changedbowner @loginame = ''sa'', @map = false'
As sp_changedbowner is deprecated in SQL 2008, it may be better to use sp_msforeachdb 'ALTER AUTHORISATION DATABASE [?] TO sa'
(if I've got that right - I always used sp_changedbowner, haven't used the new thing yet)
Tom