which query I can run to know who is the owner of the database

Question

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

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

Deepak-405225 SSCertifiable Points: 6120 More actions · Answer 1

sp_helpdb yourdbname will provide the necessary information..

[font="Verdana"]- Deepak[/font]

Suresh B. SSC-Insane Points: 22986 More actions · Answer 2

Use sp_changedbowner to set the database ower name.

Suresh

nelson.viggiani SSC Enthusiast Points: 152 More actions · Answer 3

SSC Enthusiast

Points: 152

June 6, 2008 at 6:58 am

thank you both 🙂

Deepak-405225 SSCertifiable Points: 6120 More actions · Answer 4

You can use the below command to change the dbowner in Sql 2005 servers

ALTER AUTHORIZATION ON Database::databaseName TO serverPrincipal

[font="Verdana"]- Deepak[/font]

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 5

I had the same problem some time ago. After assigning an owner to the database, the problem was solved.