Post reply

How to get Database Owner?

  • November 7, 2003 at 10:33 am

    #76076

    How do I query a sql server database to get the owner of the database? Which data dictonary views/tables have the information?

  • November 7, 2003 at 10:53 am

    #481298 

    sp_helpdb

    Or

    

    SELECT name, sid, SUSER_SNAME(sid)

    FROM master..sysdatabases

    --Jonathan



    --Jonathan

  • November 7, 2003 at 12:02 pm

    #481302

    quote:

    sp_helpdb

    Or

    

    SELECT name, sid, SUSER_SNAME(sid)

    FROM master..sysdatabases

    --Jonathan

    Why do you need an extra '.' when querying from sysdatabases

  • November 7, 2003 at 12:26 pm

    #481304

    Because he is not inserting the table owner name. If he used master.dbo.sysprocesses then he wouldn't need the double '..' DBO is assumed if the owner(schema) not specified.

    Hope this helps (HTH)

    Michelle



    Michelle

  • November 7, 2003 at 1:47 pm

    #481318

    thank you

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

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