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 |
|
X002548
Not Just a Number
15586 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-30 : 09:59:16
|
| in object explorer on database'as context menu choose Tasks-->Generate scriptsyou get a wizard that let's you do what you want._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2008-01-30 : 10:35:53
|
| DEo mean Right Click on an objectThen Script Object As...then to a file, clipboard, or new Query Window?I figured out how to script all the sprocs or tables, but it's put into 1 file, and doesn't have any other indexes or constraintsI want all the sprocs into 1 file perThe developers on a project I got thrown into create and change sprocs only on the serverBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-30 : 11:21:17
|
| Object Explorer->DbName->Right mouse click on it->Tasks->Generate scripts-> here be wizard!_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-01-30 : 13:29:13
|
| I really hate the way 2005 creates scripts from that wizard. sp_executesql is just ugly. I really wish there was a way to make it script the way 2000 does with just the simple drop and create t-sql statements.Scripting from the summary tab is close but it doesn't have the drop statements and you can't mix object types(like views, tables and SPs in one go). |
|
|
|
|
|
|
SSMS Scripting