tags:

views:

45

answers:

1
+1  Q: 

Protecting system databases in Sql Server Management Studio?

For the five hundredth time, I ran a sql script in management studio to add some tables to a database and FORGOT TO CHANGE THE DATABASE IT RUNS AGAINST. Since it defaults to master, I had to go and drop all the new tables I just added.

I practically never run sql scripts against the master database or other system databases, yet in Management Studio not only are they available in the combo box as a viable target for my scripts, but master is the default option.

Is there any way to remove system databases from this dropdown? Or, at least, change the default database from master???

+1  A: 

The default database for your login to SQL Server is set to master. Change it to the database that you use most frequently.

jl  2010-01-13 16:02:57
I love blatantly obvious and simple answers.
Will  2010-01-13 16:12:34

related questions

How do you create a parameterized query in MS Access 2003 and use other queries/forms to fill the parameters and obtain a resultset
How do I return random numbers as a column in SQL Server 2005?
SQL Text Searching, AND Ordering
How to programmatically make a Query in MS Access default to landscape when printed
SQL Query - Use Like only if no exact match exists?
SharePoint Content Query Web Part
Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc.
How to force nolock hint for sql server logins
What table/view do you query against to select all the table names in a schema in Oracle?
SQL Query to get latest price
How can I monitor the executed sql statements on a ms SQL server 2005
SQL: Select like column from two tables
C# - SQLClient - Simplest INSERT
Do indexes work with "IN" clause
Table Scan vs. Add Index - which is quicker?
Mysql: Using "AND" Operation on tags and categories tables in Wordpress
use table metadata for select statement in SQL Server?
Why are relational set-based queries better than cursors?
is it better to structure an SQL table to have a match, or return no result
SQL/Query tools?
SQL query to compare product sales by month
SQL, Auxiliary table of numbers
How do I Concatenate entire result sets in MySQL?
Multiple Updates in MySQL
Why doesn't SQL Full Text Indexing return results for words containing #?