How can we help you today? How can we help you today?

Data Generator Holds Connection to Database

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
rodney
0

Comments

1 comment

Sort by
  • 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?
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.