开发者

TSQL Openquery with Text Field hangs up MS SqlServer

开发者 https://www.devze.com 2023-01-12 05:41 出处:网络
This happens when I query a text field using linked server.For example: select * from op开发者_如何学Cenquery(LS,\'select text_field from table\')

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?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号