Time tested question! If you have finished developing and testing your ASP.Internet web application, the database you need to deploy has become filled with test information and must be purged (and identity fields reseeded to at least one) before you decide to deploy.

When utilizing a server instance, this is not difficult (produce a SQL script to complete the job) however when utilizing a user instance, its appears there's very difficult way around?

Can anybody assist with this? Thanks

You are able to connect SSMS to some user instance DB, it simply requires a bit of voodoo to uncover the DB title.

For scripting the sql, you may also make use of the Sql Server hosting toolkit to get this done.