Viewing 9 posts - 1 through 9 (of 9 total)
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....
October 24, 2002 at 6:59 pm
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(?). ...
October 18, 2002 at 8:39 pm
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. ...
September 29, 2002 at 5:09 pm
Hello all, I found help from BOL and it worked. The technique I used was detach and re-attach the database. Thanks.
July 31, 2002 at 5:22 pm
Hello all, I found help from BOL and it worked. The technique I used was detach and re-attach the database. Thanks.
July 31, 2002 at 5:22 pm
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...
July 24, 2002 at 7:44 pm
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...
June 15, 2002 at 8:24 pm
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...
June 8, 2002 at 2:42 pm
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...
May 23, 2002 at 8:38 pm
Viewing 9 posts - 1 through 9 (of 9 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy