SQL 向程序发送命令时出现问题

我使用的是 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)

相关文章