RE: default database for scripts in SSMS

From: Ben Nevarez <BenNevarez@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 27 Nov 2007 20:46:00 -0800

Change the user default database. Go to Security, Logins, right-clik your
login and select default database.

Hope this helps,

Ben Nevarez
Senior Database Administrator
AIG SunAmerica

"Ed White" wrote:

When I write a script in SSMS (I'm using SQL Server 2005), generally the
database that pops up in the pulldown window on the menu, and which the
script runs against (unless/until I change the pulldown selection), is the
master database. I'm working with only one database I've created, and I
rarely run scripts against the master database, so is there an option to have
SSMS default to my database instead of the master database?
--
Ed

Prev by Date: Re: Stronger Filter
Next by Date: Re: How to create a single reusable alert in SQL Server Agent?
Previous by thread: Re: Stronger Filter
Next by thread: Re: Performance Monitor / Database Storage using ODBC
Index(es):
- Date
- Thread

Relevant Pages

Re: Logging in irrespective of database access
... Try connecting using Query Analyzer with one of the problem logins and run ... the following in the context of your demodata and accounts databases: ... This will return the security context used to access the database. ... SQL Server MVP ...
(microsoft.public.sqlserver.server)
Re: Logging in irrespective of database access
... Try connecting using Query Analyzer with one of the problem logins and run ... the following in the context of your demodata and accounts databases: ... This will return the security context used to access the database. ... SQL Server MVP ...
(microsoft.public.sqlserver.programming)
Re: Moving logins to new server ???
... Have a look into the below link, This script will provide a easy method to ... > The website database uses SQL authentication to grant ... > There are HUNDREDS of logins. ...
(microsoft.public.sqlserver.security)
Re: Changing security authentication type.
... i'm thinking that yes in time the sa account ... A new DBA Admin User login would only be useful for SQL Login purposes. ... if appropriate you can add users to the db_owner role in a database. ... Create one or more logins for the applications. ...
(microsoft.public.sqlserver.security)
Re: Help Ive been an idiot
... You need to make sure that you readd any logins that were mapped to database ... Jasper Smith (SQL Server MVP) ... > connectionString, CommandType commandType, String commandText, ...
(microsoft.public.sqlserver.setup)