For future reference, to set the default database in SQLServer (so when you open the app, login, and click New Query, you won't have to specify the database to run against everytime), go to under the database you've connected to:
Security, Logins, & foreach the user you want this to apply to:
right click the user, Properties, & under the General tab you'll find the Default database drop-down.
Easy, huh?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment