Current DB owner, SQL Server move

I am in the process of moving the databases off an old server to a new physical server.

sp_changedbowner ... allows to set

Q1. Is there a stored procedure that shows me WHO the current db owner is ( without right clicking around)

Q2. Is there a way to move these db permissions across from old server to new server.

Thanks
3MusketeersAsked:
Who is Participating?
 
Anoo S PillaiCommented:
1) You can find out the from sys.databases; The following query will be helpful.
select suser_sname(owner_sid) from sys.databases

2) As database permissions are set within the database, permissions of database users won't lost even if you move database across servers.
BUT you should ensure that database users are not orphaned.
Please refer the following article to fix orphaned users.
http://msdn.microsoft.com/en-us/library/ms175475(v=sql.100).aspx


Hope this is helpful.
0
 
Anthony PerkinsCommented:
Q1. EXEC sp_helpdb 'YourDatabaseName'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.