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 - 2006-03-06 : 21:49:19
|
| Rajeshkumar R writes "HI, I am facing a problem with the MS SQL server 2000, the issue is when ever the SQL server machine is updated with a OS patch, the MS SQL server is becoming unstable. And first the SQL server kills all it's connections, but the assosiated program tries to reconnect and will try to comit the data, but during the second attempt the MSSQL server 2000 is granting access to a wrong database in the same machine.The comited data can be seen in the wrong database. This is causing serious problems to me.Could you please help me in this issue.Regards, Rajeshkumar R" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-06 : 21:56:18
|
| first you need to identify those patches and if you applied them correctly,next, for granting access, verify this by checking the permissions needed to commit the data and see if they are really changedisolate the problem and work from there, divide the problem into smaller chunks--------------------keeping it simple... |
 |
|
|
|
|
|
SQL server 2000 comits data to wrong database