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 |
|
raky
Aged Yak Warrior
767 Posts |
 Posted - 2010-04-05 : 01:26:31
|
| Hi,Iam encountering this error There is insufficient system memory in resource pool 'default' to run this query.Why iam getting this error when a execute any stored procedure? How to avoid it? please suggest. |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2010-04-05 : 05:17:50
|
| Does any one know the solution??? |
 |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-04-09 : 05:45:05
|
| You are getting this error when u are calling the sp from front end application or when u are executing from query analyzer.Regards,Bohra.I am here to learn from Masters and help new bees in learning. |
|
|
|
RobertKaucher
Posting Yak Master
169 Posts |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2010-04-10 : 05:39:41
|
quote:
Originally posted by pk_bohra
You are getting this error when u are calling the sp from front end application or when u are executing from query analyzer.Regards,Bohra.I am here to learn from Masters and help new bees in learning.
In both ways iam getting the same error |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-04-10 : 08:38:01
|
| What version of SQL Server are you running?Are you using Linked Servers and doing INSERTS ? It could be a memory leak?As a first step - and if it is feasible - try a restart of the SQL Server. Then look at memory consumptionJack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
|
|
|
insufficient system memory