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 |
|
influent
Constraint Violating Yak Guru
367 Posts |
 Posted - 2008-03-31 : 16:24:34
|
| Is there a way to tell SQL Server 2005 Management Studio that I don't want it to include "USE [dbname]" and "/****** Object: Table [dbo].[TBL_NAME] Script Date: [date] ******/" when it creates scripts? I searched the forums and couldn't find an answer, and I don't see it in Tools->Options. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-31 : 23:04:29
|
| May take look at default template. |
 |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2008-04-01 : 15:12:35
|
| Look at tools\Options\Scripting USE, HEADERS and many other options can be set there.Jim |
|
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2008-04-01 : 15:20:23
|
| Sorry, I don't see Scripting anywhere under Tools->Options, and I don't know how to get to the templates.Microsoft SQL Server Management Studio version = 9.00.1399.00 |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2008-04-01 : 21:13:04
|
| I'm on 9.00.3042 (SP2). Under Tools -> Options, the second to the last option in the tree on the left is Scripting. I don't know if it appears that way in RTM.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-01 : 22:49:55
|
| You can find template under view -> template explorer. |
|
|
|
|
|
|
remove junk from scripts in Mgmt Studio