none
Open .sql files in notepad

    General discussion

  • Hello,

    I have a DBA who set up a document library in SharePoint 2007.  She has a bunch of SQL script files in there (.sql)  She wants to be able to open the .sql files from the document library in notepad.  How do I do this?

    Thanks,
    Richard


    Always in need of help.
    Thursday, July 31, 2008 10:05 PM

All replies

  • Hello,

    She will need to change association of .sql extension to notepad.
    Instructions can be found bellow.
    http://support.microsoft.com/kb/307859

    Regards

    Ivan Bondy - MCPD, MCDBA, MCSA, MCTS - Sharepoint consultant
    Thursday, July 31, 2008 10:57 PM
  • Sorry, Ivan.

    Because this thread was started with a message of type "General Discussion", I can't mark your post as an Answer.

    Mike

    P.S. And I don't seem to be able to change the type of thread either. 
    Friday, August 01, 2008 11:33 AM
  • Mike,
    No problem, as long user gets the right answer.

    Ivan
    Ivan Bondy - MCPD, MCDBA, MCSA, MCTS - Sharepoint consultant
    Friday, August 01, 2008 3:04 PM
  • This is not what she is asking for.  She wants .sql files to open on her local machine the way they were intended to, but if another user (who doesn't have SQL installed on their workstation) clicks on the file it will open up in Notepad.


    Always in need of help.
    Friday, August 01, 2008 4:04 PM
  • Yes, same approach. File will open application based on extension association. If you have SQL server installed, association for .sql files is to SQL server. If you do not, you can make association to notepad. You can also change association to any other application. 

    Regards
    Ivan Bondy - MCPD, MCDBA, MCSA, MCTS - Sharepoint consultant
    Saturday, August 02, 2008 12:56 AM