我正在尝试从本地执行以下命令以截断生产中的表格 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.
更多推荐
链接服务器的问题
发布评论