sql server management studio中的远程调试

问题描述

我想访问我同事系统 SQL Server 2014 中的数据库.我在我的 SQL Server management Studio 中连接到他的系统并访问它.

I want to access DB in my colleague system SQL Server 2014. I connect to his system in my SQL Server management Studio and access it.

但问题是当我尝试调试同事数据库中的任何存储过程时，它显示以下错误

But the issue is when I try to debug any Stored Procedures in my colleague's DB, it shows the following error

错误 HRESULT E_FAIL 已从对 COM 组件的调用返回.(mscorlib)

Error HRESULT E_FAIL has been returned from a call to a COM component. (mscorlib)

无法访问 SQL Server 调试界面.访问被拒绝.无法连接到 Microsoft Visual Studio 远程调试监视器远程计算机.

Unable to access the SQL Server debugging interface. Access is denied. Can not connect to Microsoft Visual Studio Remote Debugging Monitor on the remote computer.

有人能帮我解决这个问题吗?

could anyone help me to resolve this issue?

推荐答案

你可以试试这个.

SQLCMD -S .\MYSQLSERVER2008 -U 你的用户名 -P 密码 -i C:\Database\script.sql

欲知更多详情:http://technet.microsoft.com/en-us/library/ms180944.aspx

这篇关于sql server management studio中的远程调试的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持html5模板网！