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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2010-02-16 : 12:33:09
|
| How to empty a SQL Server 2005 databse, please provide the script if any |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-16 : 13:06:44
|
| Truncate all the tables (except use DELETE for child tables of a Foreign Key relationship). Suitable script is here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65341or: if you are deploying to, say, Clients then Script the database and run the script against a freshly created new database |
 |
|
|
|
|
|
Empty the SQL database