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 |
|
vermorel
Starting Member
26 Posts |
 Posted - 2006-10-28 : 11:18:16
|
| I designing a continuous integration process, and I need to be able to "clean" the SQL Server 2005 database. Locally, I just drop the database and re-create it. That's the simplest way.Yet, I would like to do the same thing with an "hosted" database online. The problem being that I do not have the rights to drop/recreate the database. Thus I need to operation within the database.Does anyone has an idea how to drop everything in a database except the database itself?Thanks in advance,Joannès[url]http://www.peoplewords.com[/url] |
|
|
vermorel
Starting Member
26 Posts |
Posted - 2006-10-28 : 12:08:31
|
| Actually I have found the following post[URL]http://aspzone.com/blogs/john/archive/2006/07/12/1793.aspx[/URL]that deletes all the tables.But what about the constraints? (will this script work)What about the non-table objects of the database? (stored procs for ex)Joannès |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
|
|
|
How to reset the database? (continous integration)