You are here:   Articles
  |  Login

Programming Articles

Minimize
03

In Windows 7, Sql Server Express R2 with SSMS, the default database is the master database.

Not great. If you run a script and forget to specify the database, the master database could get updated.

To change the default database, in the object explorer:

Select Security, Logins
Right click your login and select Properties
Near the bottom, change the default database

Posted in: Sql

Post Rating

Comments

There are currently no comments, be the first to post one.

Post Comment

Only registered users may post comments.

Programmer Newsletter

Minimize

Subscribe to the Internet Handholding newsletter



Reccomend Programmer.bz

Minimize

Share/Bookmark Bookmark and Share