Incredible Stuff
About Me
White Lion
Well soon to be updated !
View my complete profile
Blog Archive
▼
2010
(30)
►
September
(4)
►
Sep 03
(1)
►
Sep 01
(3)
▼
August
(15)
►
Aug 30
(1)
►
Aug 21
(1)
►
Aug 20
(1)
►
Aug 19
(1)
►
Aug 18
(1)
▼
Aug 17
(5)
Validating Backups & Restore Verification
Backup History Analysis Script !
Attaching n Detaching Dbs !
How to change a dbowner for a db ?
How to find who the db owner is for a specific db ?
►
Aug 16
(2)
►
Aug 15
(1)
►
Aug 11
(2)
►
April
(2)
►
Apr 15
(1)
►
Apr 10
(1)
►
February
(5)
►
Feb 13
(2)
►
Feb 07
(1)
►
Feb 06
(1)
►
Feb 02
(1)
►
January
(4)
►
Jan 27
(1)
►
Jan 26
(3)
Followers
Tuesday, August 17, 2010
How to find who the db owner is for a specific db ?
select name,suser_sname(owner_sid) from sys.databases
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment