SQL 2012 Database Owner

Question

Post reply

SQL 2012 Database Owner

m.atiq.butt

SSC Veteran

Points: 220
More actions
January 5, 2016 at 11:48 pm

#314643

How can i change the owner of sql database when i don't have the SSMS to work with

Viewing 10 posts - 1 through 9 (of 9 total)

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

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 1

You can try from SQLCMD.

Thank You.

Regards,
Raghavender Chavva

m.atiq.butt SSC Veteran Points: 220 More actions · Answer 2

m.atiq.butt

SSC Veteran

Points: 220

January 6, 2016 at 1:20 am

#1849756

have to put ownerchanged query over sqlcmd?

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 3

sqlcmd -S instancename -q "SELECT * FROM AdventureWorks2012.Person.Person"

Thank You.

Regards,
Raghavender Chavva

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 4

You can use EXEC sp_changedbowner to change the ownership.

(In fact, that is probably exactly what the SSMS UI does when you click those buttons).

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

m.atiq.butt SSC Veteran Points: 220 More actions · Answer 5

sqlcmd is shutting down after about 10 sec and not allowing me to write command

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 6

Write the sqlcmd command on notepad and paste it in cmd.... Try in this way

Thank You.

Regards,
Raghavender Chavva

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 7

If you just used copy/paste on what Raghavender posted, then you told the SQLCmd tool to execute a single query (listing all data from one of the AdventureWorks tables) and then exit.

Either replace that query with your own, or (my preference) connect with the correct options to give you an interactive window where you can type and execute queries.

Check Books Online for a full description of all command-line options for sqlcmd.exe.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 8

you can also use ALTER AUTHORIZATION

ALTER AUTHORIZATION ON DATABASE::MyDatabaseName TO NewOwner;

GO

or alternately use sp_changedbowner statement

m.atiq.butt SSC Veteran Points: 220 More actions · Answer 9

m.atiq.butt

SSC Veteran

Points: 220

January 9, 2016 at 7:38 am

#1850749

Thanks A lot every one

I have found the solution