Below is the exact error i m getting , here i m printing my dynamic SQL.

and i have calculated its lenght its more then 8000 bytes. and with this

i m...

hi,

The Error comes bcoz , see

my @STR varibale is having more then 8000 bytes characters ok,

now when i executes it excutes upto 8000 bytes only so it is...

sir, thanks for the reply

its a long sp of balance sheet and earlier it is using dynamic sql now we need to do some modification and needs to add two...

hi,

y dnt u try with the trigeers like

create trigger t1

on quiz

for update

as

declare @id int,@t1 numeric,@t2 numeric

select @id=user_id1,@t1=points from inserted

select @t2=points from quiz where user_id1=@id

update quiz set points=@t1+@t2 where user_id1=@id