Default Database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Default Database

Default Database

Rate Topic

Display Mode

Topic Options

Author

Message

egonzalez-808751

Posted Tuesday, November 10, 2009 10:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 17, 2012 1:26 PM
Points: 2, Visits: 43

How do you know which is your default database for your server?

Post #816688

Crosan

Posted Tuesday, November 10, 2009 11:22 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 1:14 PM
Points: 130, Visits: 304

sp_helplogins should tell you this, look in the DefDBName, but will require elevated priviliges to run. Otherwise you can go to a database the user has been added to and run:

sp_helpuser 'UserAccountHere'

Post #816698

Amit Singh

Posted Tuesday, November 10, 2009 11:29 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, May 05, 2013 3:41 PM
Points: 110, Visits: 368

sp_helplogins 'your loginame' would give you the default database name along with other info ...... If you are just looking for login name and default database .... you could run this

select [name],dbname from sys.syslogins

-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! w00t

- desparately trying to fish

Post #816704

egonzalez-808751

Posted Tuesday, November 10, 2009 2:11 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 17, 2012 1:26 PM
Points: 2, Visits: 43

Thay you two for the replies. That's exactly what i needed.

Post #816831

« Prev Topic | Next Topic »

Permissions