Hi!
Is it possible to set the database owner using the "create database" command?
Thank you!
Hi Ana,
No, the CREATE DATABASE statement does not have a "owner = <name>" clause. The owner is the user that creates the database. The database owner can be changed by using sp_changedbowner. See this Books Online topic for details: http://msdn2.microsoft.com/en-us/library/ms178630.aspx.
Regards,
Gail
|||Thank you!
No comments:
Post a Comment