Post reply

Default DB

  • December 16, 2009 at 2:37 am

    #156508

    Hi,

    I'm looking for an easy way to find out what the default database is set for sql logins. I can do this via ssms but I wanted to know if anyone has a script which will show these details as I have quite a lot of dbs on each instance.

    Thanks

  • December 16, 2009 at 3:04 am

    #1092887

    Check out the dbname field from the sys.syslogins. This is the default database per login.

  • December 16, 2009 at 3:16 am

    #1092888

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

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