.sql don't "open with" MSDE

[sharonniles]

I just installed MSDE. But, .sql files open in Notepad. How do I get them to open with SQL Server 2000?

Thank you,
Sharon Niles

 

[dbomrrsm]

you have to associate them with isqlw.exe - in your windows explorer tools options look at file types then find the sql extension then below that it lets you choose which porgramme to open the sql file with if its not in the list choose browse and find it at

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\isqlw.exe

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[sharonniles]

I don't have isqlw.exe. I've downloaded the MSDERelA twice and installed (and removed) SQL Server about 6 times. Any suggestions?

Thank you.

 

[mrdenny]

MSDE doesn't come with isqlw.exe. isqlw is Query Analyzer. The client tools aren't included with MSDE. You have to edit the file within notepad and use isql or osql to execute the file against the SQL Server database.

isql and osql are command line utilities that can run saved SQL Files against SQL (and MSDE). Use isql /? or osql /? for the full set of options.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)