Viewing 15 posts - 316 through 330 (of 398 total)
I am waiting for my user to finish this extremely long select into statement so that I can test your suggestions on my server. I'll update as soon as...
November 12, 2002 at 10:25 am
One more thing, in EM>Process Info.
The sa user has one process that under the Database column has "no database context" and the Command column has "CHECKPOINT SLEEP".
There are three system...
November 8, 2002 at 9:14 pm
Nothing in the log files, nothing. Thats why this is so hard to fix.
I should mention one more thing, the other table that did not have problem not only...
November 8, 2002 at 9:03 pm
Well, its actually more like a process was run 200 hours before and was still running. I queried sysprocesses.last_batch and the last batch that was run was run 200...
November 1, 2002 at 5:29 pm
samiu, I am interested in learning more about the monitoring server and how that works. Where can I get more info on that and the script written by Greg?...
October 28, 2002 at 11:23 am
racosta, you wrote:
"Every time you backup the log, the commited transactions that are saved in the log are deleted, so the log file size decrese."
Thats what I thought would happen...
October 25, 2002 at 9:14 am
I stopped and started the sql server service and that fixed it. It happened again later though. I think the latest sql server patch (is the latest patch...
October 24, 2002 at 6:08 pm
Andy, I agree with you, but its not my decision.
October 22, 2002 at 5:24 pm
I am curious, how do you guys see the process is rolling back after you kill it?
October 16, 2002 at 2:32 pm
I am not sure how it happens, I think its due to normal queries. It is all over my logs, its happening more than 100 times in a day.
...
October 16, 2002 at 12:44 pm
The job invokes the main procedure which in turn calls other procedures. The last procedure sends out a mail with the result of the process. This used to...
October 15, 2002 at 8:01 pm
No, nothing like that. Actually I moved the LTO tape to another slot and ran the backup and it worked. Somehow Backup Exec has a problem (on a...
September 13, 2002 at 6:12 pm
Thanks for the info. I created another filegroup and moved data to that filegroup. However, I tried to move the indexes to another filegroup on another drive (by...
September 12, 2002 at 11:55 am
The .dmp file is too big, should I post it anyways? Does this forum allow me to post such a big file?
August 28, 2002 at 2:22 pm
I see, I went to the registry location
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer and changed the MSSQLServer directory name. I was then able to install a default instance of SQL Server. I...
August 23, 2002 at 2:01 pm
Viewing 15 posts - 316 through 330 (of 398 total)