Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-12-08 : 23:00:46
|
| Dear All,When i monitored the Event log viewer i found an error."There is insufficient memory to run this query" for the Tuesday 07/12/2010.and because of this all my scheduled jobs are failed and created big fuss.I want to check which query or stored proc or function to have insufficient memory for the Tuesday on 7/12/2010.Thanks,Gangadhar |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2010-12-08 : 23:36:12
|
| There may be some clues in the errorlog, I think a 701 gives you part of the input buffer in the errorlog.-Chad |
 |
|
|
|
|
|
Query causing the issue