Forum Discussion

richv's avatar
richv
Occasional Contributor
12 years ago

Testcomplete does not disconnect from database

I am using DBtable compare at the a number of stages in my test.  After the DBtable compare i try to re instate my database for another test When I try to overwrite the database just used for the D...
paul_scroce's avatar
paul_scroce
Frequent Contributor
12 years ago
If you are restoring an SQL database try this step to disconnect all users



http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=170474



Step (3): Disconnect all users



If you are restoring over an existing database make sure all currently connected users are disconnected

(If you are restoring to create a brand new database skip this step)


ALTER DATABASE MyTargetDatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE