CODEWITHSUNDEEP
sql-server-2008
s.keerthi vidhyasagar
s.keerthi vidhyasagar

Reputation: 11

Error opening the .sql file

Whenever I double click on .sql file. I receive a message that 'There was a problem sending the command to the program'

Upvotes: 1

Views: 220

Answers (2)

user3146115
user3146115

Reputation:

I was facing same issue. I don't know what problem it, but I have fixed it with a registry hack.

  1. Run regedit and go to the following key:
  2. HKEY_CLASSES_ROOT\sqlwb.sql.9.0\Shell\Open\Command
  3. Update the (Default) value
  4. It should contain something like: "c:\Program Files(x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\ssms.exe" /dde
  5. add "%1" to the end
  6. the value sholud now like this: "c:\Program Files(x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\ssms.exe" /dde "%1"

Upvotes: 0

Rahul Tripathi
Rahul Tripathi

Reputation: 172628

See the MSDN which says:

Ah... I think the solution is to make the string for

HKEY_CLASSES_ROOT\sqlwb.sql.9.0\Shell\Open\Command

say this:

"C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\ssms.exe" "%1" /dde

with quotes around the %1. It works for me now.

I think this is a bug in SQL Server 2008 client tools.

Upvotes: 1

Related Questions