May 19, 2010 at 2:39 pm
while executing this query i got an error stating that 'Msg 802, Level 17, State 20, Line 1
There is insufficient memory available in the buffer pool.'
Query is
create function V_exec
(@string varchar(300))
returns varchar(300)
As
begin
declare @string3 varchar(300),
@string2 varchar(300)
select @string3=isnull(stuff(@string,charindex('.',@string),charindex('\',@string,3)-charindex('.',@string),''),@string)
select @string2=substring(@string3,charindex('\',@string3),len(@string3))
select @string=substring(@string2,0,charindex('\',@string2,charindex('\',@string2,charindex('\',@string2,charindex('\',@string2,charindex('\',@string2)+1)+1)+1)+1))
RETURN @string
end;
select dbo.V_exec(source) from install
where Source like '\\%'
where install is a table which got nearly more that 2 million records
May 19, 2010 at 2:41 pm
Here is a doc that outlines some troubleshooting measures for this error:
http://msdn.microsoft.com/en-us/library/cc966540.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply