October 9, 2003 at 9:06 am
We are experiencing the following error:
Error: 17883, Severity: 1, State: 0
The Scheduler 0 appears to be hung. SPID 53, ECID 1, UMS Context 0x04069D90
We can find information @
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B810885
We are guessing it is being caused by the AUTOGROW of files (explicit or implicit).
We have our DB set to autoshrink and we DTS very large files in once a day, say around 250 megs each.
We have since removed the autoshrink setting on DB but was just wondering if anyone else has experienced this error?
Thanks
October 9, 2003 at 1:16 pm
Someone posted similar question few days agao. You may search that.
I have seen this problem in one of my servers and hardware vendor is pointing to possible hardware issues.
October 10, 2003 at 1:56 am
Sometimes this occurs when SQL Server Agent can not authenticate the user who owns/starts the job. Search the MS KB for "xp_logininfo", I can't remember the article directly
October 10, 2003 at 8:14 am
Though the article on MSFT link says for SQL 2000, but we did have this problem on SQL 7.0. The error was similar, but with a different error no. It was caused due to running out of RAM and server not able to release memory in a timely fashion.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply