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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-09 : 08:19:18
|
| sagasasolutions writes "I worked in a bank process application using vb vs SQLserver7. I will try the restore coding in visualbasic6.0 but it has an an ODBC error - " exclusive acccess couldn't be obtained because of database is in use and restore database is termnating ubnormally and ". how to rectify the error is in visualbasic coding. pls give ideas or code for the above error. pls reply immediately.Thanking You " |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-09 : 16:37:35
|
| You need to disconnect all users in your database before performing a RESTORE. So run sp_who to see who is connected then KILL those spids.Tara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-09 : 16:50:10
|
| Why are you trying to do DBA functions using VB?Brett8-) |
|
|
|
|
|
|
I want to rectify a Restore database error while using SQL