I am using a dynamic stored procedure, the parameter value is really long (more than 10000 characters).
And another stored procedure is calling inside the dynamic query (@SP), when I execute the SP the parameter being truncated.
Because of this I am unable to execute the query
How can I get the entire parameter? Did I miss some thing??
ALTER PROCEDURE [dbo].["SP_NAME"]
@ID varchar(50),
@<parameter Go to the complete details ...