how to check my database owner?

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

In Management Studio, you can right-click the database and go to Properties, and it will tell you who created it and when.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Deviprasad Ten Centuries Points: 1060 More actions · Answer 2

select suser_sname(owner_sid) from sys.databases where name = 'YourDB_Name'

Cheers

Dev

SQL2016 SSC Eights! Points: 990 More actions · Answer 3

SSC Eights!

Points: 990

July 26, 2008 at 1:21 am

Thanks,

luv's

Milu..:)

Venkatesan Prabu SSCommitted Points: 1892 More actions · Answer 4

Hope,

The below article will help you,

Thanks and Regards,
Venkatesan Prabu, 😛
My Blog:

http://venkattechnicalblog.blogspot.com/

elchuru Default port Points: 1435 More actions · Answer 5

We can change the daatabase owner using sp_changedbowner or using ALTER AUTHORIZATION.

elleevan1 SSC Enthusiast Points: 144 More actions · Answer 6

thank you for sharing

eBay redemption code | Petsmart grooming coupons