Data Generator Holds Connection to Database

rodney

I used data generator to generate some data, then wanted to restore my database to its original state. This requires exclusive access to the database, but it appears that the SQL Generator app holds its database connection, even if you close the project it still seems live until you close the whole application.

Closing and reopening the app is a work around, but is there something more obvious?

Thanks

Chris Auckland

Thanks for your post.

Which version of SQL Server are you using? This doesn't appear to happen when I tested it with SQL 2008 and SQL 2012.

Are you restoring using native SQL or something else?

What does sp_who2 show you for the connection to the database you're trying to restore?