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 |
|
albertkohl
Aged Yak Warrior
740 Posts |
 Posted - 2007-10-26 : 18:31:04
|
| In Sql2000 there was an option to script a database in enterprise manager. running this would script your structure, statistics, indexing as well as a number of other things all in one process. how would i go about doing the same in sql2k5? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-10-26 : 19:53:51
|
| You can do the same in 2005 too, Right click on Database -> Tasks -> Generate Scripts.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-29 : 03:09:51
|
| In 2005 it is under Management studioMadhivananFailing to plan is Planning to fail |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-29 : 04:49:20
|
| You can either script all or pick just certain elementsJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
script database