問題描述
我想訪問我同事系統 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模板網！