Click here to Skip to main content
15,887,596 members

Comments by zzbsforever (Top 3 by date)

zzbsforever 14-Oct-12 23:24pm View    
Thanks a lot. I have tried to verify this method. But I got this message:
Server '<linked Server Name>' is not configured for RPC.
I don't have permission to change the linked server options.But I think your method is better if it is working fine.
zzbsforever 13-Dec-11 4:33am View    
I tried in this case, but temporary table is not support in openquery
zzbsforever 13-Dec-11 4:32am View    
I am working on a maintenance project which needs to pass some input parameters to openquery. Parameter Line_id(used in openquery) is got based on 'Project Code'(used in sql), this cause the problem which line_id is too many for one project_code.