Restrictions on exec command

[pgk]

Hi,

Are there any restrictions regarding the use of dynamic sql with the exec statement?

I have a varchar(2500) field that holds a dynamically built sql in a SP. I execute this using exec ( @final_select ). My SP just runs forever.

I tried out the same stuff using DBArtisan and it returns in less than 5 seconds.

Any ideas??

Thanks a lot.

With regards,
Ganesh