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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2007-04-22 : 02:54:05
|
| i recently moved from sql server 7 to sql 2005 -- in sql 7 if i wanted to generate an sql script then It would generate a whole script ---in sql 2005 - when i do generate it seems to attach a file -- I want to generate a script that I can then modify and use to create a new db -- is this possible? |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-22 : 03:06:59
|
are you using Generate Scripts Wizard in SSMS? that should generate scripts for the whole db.
www.elsasoft.org |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-04-22 : 03:13:46
|
| i right clicked on the table and did script database as but the script included reference to a file and not a script of all tables,view,and storedproceduresplease advise? |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-04-22 : 03:32:50
|
| never mind -- i found it -- thanks... |
|
|
|
manishkaushik
Starting Member
14 Posts |
Posted - 2007-05-03 : 10:36:10
|
| Hi,Can any one tell me, how can i generate the sqlscript for all the tables and the storedprocedure and triggers of my Database, i successfully generated the sqlscript of the database. but it does not contains the tables the stored procedures and the triggers within it.I am using Sqlserver 2005.Thanks and Regards.Manish Kaushik |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-03 : 12:58:52
|
| Right click on the db and go to task -> generate scripts, check 'script all objects in the selected database' then go. |
|
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2008-01-25 : 14:41:34
|
| It works great!Thanks |
|
|
|
|
|
|
generate script