Hello,

I'm trying to test to see what an error is being caused by, but all I'm getting in the result set back is:

The command(s) completed successfully.

Does anybody know why it isn't even selecting anything? What is this a sign of? I'm creating a dynamic SQL string, which I'm executing via the sp_executeSQL proc. For testing, I'm using print @SQL, which in Query Analyzer was returning something. Now it isn't working.

Also, the concat_null_yields_null option is set to off.

Any help is appreciated?

Thanks,

Brian

__________________
Brian

Hi,

It will help others to determine what is causing your particular problem if you post your code.

on the second hand; use profiler to trace your root cause.