問題描述
我使用的是 Windows 7 和 SQL Server 2008 R2，每當我嘗試雙擊一個 .sql 文件時，我都會收到一些愚蠢的錯誤將命令發送到程序時出現問題"有誰知道如何解決這個問題?每當我打開 SQL 服務器或 BIDS 時，我都會不斷彈出 UAC，但由于某種原因，在 Vis studio 2010 中似乎沒問題...哦，我檢查了 exe 是否以管理員身份運行，我看到它發布在某處...
I'm using Windows 7 and SQL Server 2008 R2 and whenever I try and double click a .sql file I get some stupid error "there was a problem sending the command to the program" does anyone know how to fix this? I have UAC keep popping up whenever I open SQL server or BIDS, but seems fine with Vis studio 2010 for some reason... oh and I checked that the exe was running as admin, I saw that posted somewhere...
推薦答案
我的一開始也是這樣.
運行 regedit 并轉到以下鍵:
Run regedit and go to the following key:
HKEY_CLASSES_ROOT\sqlwb.sql.9.0\Shell\Open\Command
HKEY_CLASSES_ROOT\sqlwb.sql.9.0\Shell\Open\Command
編輯默認值以在末尾添加%1".
Edit the default value to add "%1" to the end.
該值現在應如下所示:
"c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\ssms.exe"/dde "%1"
"c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\ssms.exe" /dde "%1"
(注意 %1 周圍的雙引號)
(note double quotes around the %1)
這篇關于SQL 向程序發送命令時出現問題的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！