Thx for the responses.

well the statement is not that simple. Actually i took some sample example. But i cant apply that workaround for a stmt like this.

CREATE PROCEDURE P1(@id...

Steve,

Thx for the response.

But the SP can take input as text and can return ouput as text.

So if this is possible, then iam trying to figure out how can store...

Hope this helps....

http://www.swynk.com/friends/krishnan/tranlogshrink.asp