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-09-12 : 07:40:23
|
| Sharat writes "Hi, i am using sql server 2000 which works well for 5 days in week but after remaining inactive for saturday and sunday it looses odbc connectivity and i see the database in a single user mode without any reasons or errors, so on every monday i have to restart the sql server mannually, i checked event logs but there was no errors, all the jobs are fine, there is no job failure.what could be the possible reason for this?regards" |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-12 : 08:14:49
|
| I am betting there is a job that uses ALTER DATABASE over the weekend that puts your DB in single user mode and forgets to switch it back to multi user. Have you checked the sql server serror log? you can run the profiler over the weekend to capture the ALTER DATABASE statement.====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
 |
|
|
|
|
|
sql server 2000 odbc disconnection