TSQL Openquery with Text Field hangs up MS SqlServer
This happens when I query a text field using linked server. For example: select * from op开发者_如何学Cenquery(LS,'select text_field from table')
then my server blows up! HELP?
There is not much information you provided.
Probably, one or both of the servers are busy, the table is very large and the link between them is slow.
What happens if you run the query directly on the remote server?
精彩评论