Home Forums SQL Server 2005 T-SQL (SS2K5) Get the DB Owner through T-SQL RE: Get the DB Owner through T-SQL

  • June 3, 2009 at 1:15 am

    #1003802

    sqluser (6/3/2009)

    Hi All,

    Is it possible to get who is created a database through T-SQL?

    For Ex, if i see the Properties of a database there is a column called owner (who is created the database).

    Likewise, through T-SQL is it possible to achieve the same owner?

    Appreciate your help!!!

    ---

    You can get the owner of the database by running sp_helpdb. But the owner is not necessarily the user who created the database. In fact on most of the databases I work with, we change the owner to sa.

    [font="Verdana"]Markus Bohse[/font]