Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2005-08-21 : 17:07:04
|
| How to find out the login , that is the owner of the database . I mean if i havea database say DB1 I want to find out , which login user is the owner of this DB Thanks |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-08-21 : 17:25:39
|
| select suser_sname(sid)from master..sysdatabaseswhere dbid = db_id('DB1')( or use sp_helpdb )rockmoose |
 |
|
|
|
|
|
DB Owner