August 8, 2006 at 12:02 am
i am looking for a simple way of determining the database owners so that i am able to make sure i do not have any databases owned by an account that will be disabled shortly.
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
August 8, 2006 at 3:00 am
in query analyser run the following
use master
go
exec sp_helpdb
the 3rd column shows database owner
MVDBA
August 10, 2006 at 2:16 am
This will show you the owner of any databases
select
name, suser_sname(sid) [User]
from
master.dbo.sysdatabases
-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible. :crazy:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply