Post reply

Error:

  • May 19, 2010 at 2:39 pm

    #386968

    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

    #1169755

    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