Uripedes,

what do you mean of CTE? this is new for me.

Thanks

Lindsay

Thanks a lot cherish:)

The query you offered should worked for us, but it won't work if I moved the select query out of the EXECUTE string. seems that they are...

Thanks a lot Jeffrey.

I only want to use that temp table to compare the data with another table on that remote server. But like you explained, the process has finished...

Thank you ALL:)

Yes, the EXEC will return inconsistent number of COLUMNS, because it is one SP which can help us do something..... I tried the OpenQuery, seems that it works...

Thanks a lot Lowell. It works for me^_^

Thanks

Lindsay

Thanks for your reply all^_^

Basically, I only want to filter out the table info after in one query, but the format after "From" is different, sometimes, it it has only...

Thanks a lot SQLkiwi ^_^

Thanks

Ling

Thanks a lot sturner ^_^

I modified the gloable temp table name with PID info, in case there is any conflict with other run. but I found I can't deliver the...

Yes, you are right. Thanks a lot:)

Thanks

Lindsay

I have found the solution. use the following command and successully. and then run the execution should work. Share is with you guys, in case someone hit same issue:-)

exec sp_configure...

Thanks for your reply rajiv^_^

actually,I have already added linked server, which name is ALS. that's why I got the error in my original post when I call store proc via...