链接服务器的问题

本文介绍了链接服务器的问题的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试从本地执行以下命令以截断生产中的表格 truncate table server1.udupikrishna.dbo.emp1 b $ b 但它会抛出：消息4701，等级16，状态1，行1找不到对象emp1因为它不存在或者你没有权限。 server1是我的链接服务器。 server1是我在本地环境中设置的链接服务器。 我们不能在链接服务器上执行删除操作。 如果是permisiion问题那么我可以从哪里来设置链接服务器的修改权限？ 问题2

i am trying to execute following command from local to truncate table on production truncate table server1.udupikrishna.dbo.emp1 but it throws :Msg 4701, Level 16, State 1, Line 1 Cannot find the object "emp1" because it does not exist or you do not have permissions. server1 is my linked server. server1 is my linked server i have setup in local environment. cant we perform delete operation on linked server. if it is permisiion issue then from where i can set modification permission to link server ? ISSUE 2

declare @NumRow int= 0 select @NumRow = count(id) from emp BEGIN TRAN t1 insert into server1.udupikrishna.dbo.emp1 (name) select name from emp IF (@@ROWCOUNT = @NumRow AND @@ROWCOUNT > 0 ) BEGIN COMMIT TRAN t1 print 'Inserting Records..' delete from emp END ELSE BEGIN print 'There are not any record to insert..' ROLLBACK TRAN t1 END

以上查询返回错误： OLE DB提供程序SQLNCLI 11用于链接服务器server1返回消息伙伴事务管理器已禁用其对远程/网络事务的支持。。 消息7391，级别16，状态2，行4 无法执行操作，因为链接服务器server1的OLE DB提供程序SQLNCLI11无法开始分布式事务。

Above query return error: OLE DB provider "SQLNCLI11" for linked server "server1" returned message "The partner transaction manager has disabled its support for remote/network transactions.". Msg 7391, Level 16, State 2, Line 4 The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "server1" was unable to begin a distributed transaction.

推荐答案

所有，你需要解决权限问题...正如我之前写的，阅读这些文章： msdn.microsoft/en-us/library/ms175537%28v=sql.105%29.aspx [ ^ ] msdn.microsoft/en-us/library/ms188279.aspx [ ^ ] http：/ /msdn.microsoft/en-us/library/aa560998.aspx [ ^ ] http： //msdn.microsoft/en-us/library/ms190479.aspx [ ^ ] First of all, you need to solve problem with permissions... As i wrote before, read these articles: msdn.microsoft/en-us/library/ms175537%28v=sql.105%29.aspx[^] msdn.microsoft/en-us/library/ms188279.aspx[^] msdn.microsoft/en-us/library/aa560998.aspx[^] msdn.microsoft/en-us/library/ms190479.aspx[^]

Maciej los''链接非常实用。 你也可以尝试这个：合作伙伴事务管理器已禁用其对远程/网络事务的支持，这可能会引导您获得大量相关事实。 Maciej los'' links are quite useful. You can also try this one : The partner transaction manager has disabled its support for remote/network transactions, which will likely lead you to plenty of relevant facts.