<div>
Q1. EXEC sp_helpdb 'YourDatabaseName'
</div>


<div>
<div class="content wysiwyg-content">
I am in the process of moving the databases off an old server to a new physical server.<br />
<br />
sp_changedbowner ... allows to set <br />
<br />
Q1. Is there a stored procedure that shows me WHO the current db owner is ( without right clicking around)<br />
<br />
Q2. Is there a way to move these db permissions across from old server to new server.<br />
<br />
Thanks
</div>
</div>


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

Current DB owner, SQL Server move

The Microsoft Legacy Operating System topic includes legacy versions of Microsoft operating systems prior to Windows 2000: All versions of MS-DOS and other versions developed for specific manufacturers and Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions, and Windows Mobile.

Microsoft Legacy OS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.