Wednesday, March 21, 2012

How to change default database ?

Hi!

Everytime I start SqlStudio my default database is "master".
I don't like it and would change it but how ?
Let's say for my "DotNet" database.

Jedrzej

Change the default database for the user you are connecting with either through the GUI (Server > Logins > default database) or with the procedure sp_defaultdb.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment