August 31, 2001 at 1:54 pm
I get an error
error : 17803 Security :20 Status:14
Insufficient Memory Available
Error occured afer running 150 jobs sequentially and i am running sqlserver 2000 on windows 2000 server.
Can someone help in this issue.
Thanks
Balaji
August 31, 2001 at 2:20 pm
Besides running SQLServer 2000 can you give more specific information like amount of memory on box, is SQL running on dedicated memory or dynamic memory allocation. You wouldn't by chance be running a trace on this server either would you?
At any rate, more information is definitely needed.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 31, 2001 at 2:25 pm
Balaji,
You may want to check out Q267953 to see if this meets your conditions as well. This is an apparent bug in 2000 under certain conditions. Worth a look anyway.
Are you running SP1 for SQL Server and what SP for Windows 2K?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 31, 2001 at 4:08 pm
What kind of job? TSQL? ActiveX? By sequential do you mean that you actually waited on job#1 to complete before job#2 started, or you just started #1, then #2, etc. If you're using any type of COM you might want to look at the task list while the jobs are running, maybe something is not terminating correctly.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply