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 |
|
Mickybee
Starting Member
29 Posts |
 Posted - 2006-05-10 : 08:21:22
|
| Hia all,Big apologies for posting a really silly question and I have tried to find a similar answer on the forum but haven't spotted it.Im basically playing with my own database (it looks really nice and has about 30 tables full of data.I have tried to create a script which will allow me to re-create the database with all the data but I can't work out how to add the data.Ive tried the script 'Script Table as' for each table but it just gives me the table columnds and no data.What am I doing wrong. Sorryp.s. Im using SQL Server 2005 Standard edition if that helpsCheers in advanceMike |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
Mickybee
Starting Member
29 Posts |
Posted - 2006-05-10 : 08:37:55
|
| Cool thanks,Ive taken the script and run it, it says run successfully but Im not sure what should have happened. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-10 : 10:28:09
|
| It creates a stored procedure, If you run the stored procedure with your table name it willgive a resultset of the insert statements==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
data export scripts