Change owner on sql server db.

CHANGE owner ON sql server db.
 
Restore DATABASE FROM .bak file
 
CREATE login
give dbo role.
 
 
Run the script:
 
 
USE db
go
 
SELECT ‘EXEC(”sp_changeobjectowner @objname = ””’+
ltrim(u.name) + ‘.’ + ltrim(s.name) + ”””
+ ‘, @newowner = NEWOWNER”)’
FROM sysobjects s,
sysusers u
WHERE s.uid = u.uid
AND u.name ‘NEWOWNER’
AND xtype IN (‘V’, ‘P’, ‘U’, ‘FN’)
AND u.name NOT LIKE ‘INFORMATION%’
ORDER BY s.name
 
copy paste result TO query analyzer
 
go
 
DELETE old user
 
exec sp_changedbowner ‘newowner’
 
CHANGE login name FOR dbo TO newowner (pwd = same)
bmssa/bmssa