sql server replication: Good moorning ...

I need to retrieve all the database owners in my server by database, and
after that change the owner of all this databases to sa user.

Thanks in advance for you help.

Richard

You could run the following statement to find out all the databases that are
not owned by 'sa', and change the owner to sa by using sp_changedbowner.


SELECT name AS DatabaseName, SUSER_SNAME(sid) AS OwnerName
FROM master.dbo.sysdatabases
WHERE SUSER_SNAME(sid) <> 'sa'

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm


[quoted text, click to view]
Good moorning ...

I need to retrieve all the database owners in my server by database, and
after that change the owner of all this databases to sa user.

Thanks in advance for you help.

Richard