I found out the Profiler tracing incorrect server was in fact a known bug for sp3 which our server is using. See the link for article on Microsoft site....

We executed sp_dropserver and sp_addserver. So, the sysservers table is showing the correct server. I will look into any aliases that may have been setup by accident(?). ...

This job is triggered from a VB application and involves reading from the database to generate reports through a series of steps - opening cursors, creating temp tables, etc. ...

Hello all, I found help from BOL and it worked. The technique I used was detach and re-attach the database. Thanks.

Hello all, I found help from BOL and it worked. The technique I used was detach and re-attach the database. Thanks.

Thanks for the tip. I read the article and it's very informative. Looks like there is no straightforward way to copy the dts packages. I guess the...

I did not explicitly declare a read only cursor. I have in fact experimented with different combinations of cursor declaration such as dynamic, for update, scroll lock,..

I...

This is my understanding of how dbcc dbreindex works. dbcc dbreindex rebuilds indexes only. For a table with a clustered index, dbcc dbreindex will rebuild the datapages with...

It eventually get cleared and the database was back to normal.

This was how the db got into the "recovery" state:

I shutdown SQLServer trying to kill some rollback event...