Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SoftFox
Starting Member
42 Posts |
 Posted - 2008-05-20 : 03:49:01
|
| When creating scripts in SQL 2005 Server Management Studio for stored procecures, views etc, it automatically enters the target database e.g. "USE [databasename]". Does anyone know how to turn it off so it doesnt add this? |
|
|
Zack
Starting Member
26 Posts |
Posted - 2008-05-20 : 13:23:12
|
| Are you creating your scripts using the export function? If so there's an option under "Choose Script Options" called "Script USE DATABASE" which is set to true by default. Change that option to false. |
 |
|
|
|
|
|
Create scripts in SQL 2005 Server Management Studi