Home Forums SQL Server 7,2000 In The Enterprise Insufficient Buffer Space issues RE: Insufficient Buffer Space issues
Roy Ernest
SSC-Dedicated
Points: 38780
More actions
May 12, 2009 at 8:13 am
#992971
I have a feeling that quite a bit of your Stored Procs are compiled with out the "SET NOCOUNT ON" . This can eat up your Buffer Space. Restart will fix it but it will come back again if you have the above mentioned problem
-Roy