Page 1 of 2 12 LastLast
Results 1 to 15 of 16

Thread: SQL Server 2005 Opening Script File Problem

  1. 10-17-2008, 02:28 AM #1
    prashant12se
    prashant12se is offline Registered User
    Join Date
    Oct 2008
    Posts
    22

    SQL Server 2005 Opening Script File Problem

    Hi All,
    I just installed SQL Server 2005 on my PC. I have some scripts written by one of my friend to create some tables and stored procedures. Whenever I go to open the script file the file opens in Notepad instead of appearing in the query window.
    How can i correct this.
    Reply With Quote Reply With Quote
  2. 10-17-2008, 08:32 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You need to change association in windows. Try assoc command in command prompt or go to Windows explorer and go to Tools - folder options - File type and change association.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
  3. 10-17-2008, 08:51 AM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Is file extension .sql? Will load .sql file in ssms by default.
    Reply With Quote Reply With Quote
  4. 10-20-2008, 03:55 AM #4
    prashant12se
    prashant12se is offline Registered User
    Join Date
    Oct 2008
    Posts
    22
    Hi skhanal,
    i did the above by making the sql extn as default in windows explorer but the .sql file still opens in notepad.
    Reply With Quote Reply With Quote
  5. 10-20-2008, 10:31 AM #5
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    try this

    CMD>assoc .sql=sqlwb.sql.9.0
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
  6. 10-20-2008, 12:28 PM #6
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Or just right click .sql file and go to open with -> choose program..., select ssms then check 'always use the selected program to open this kind of file'.
    Reply With Quote Reply With Quote
  7. 10-20-2008, 05:09 PM #7
    Island1
    Island1 is offline DBJ Author
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    A Simple Association is All You Need ....

    It's a common question. The response just before this one is what I tell clients / readers regularly ...

    Let us know if that doesn't do it for you ...

    Bill
    Reply With Quote Reply With Quote
  8. 10-21-2008, 01:03 AM #8
    prashant12se
    prashant12se is offline Registered User
    Join Date
    Oct 2008
    Posts
    22
    Hi skhanal,
    tried the above command on cmd prompt but the .sql file still opens in notepad and the contents are non-readable charaters. Is it something to do with the edition, i am using standard edition of MS-SQL 2005.
    Although the MSSMS gets open on click of .sql file but the end result is that the the contents of sql file opens in notepad. I think the MSSMS is making the .sql file to open in notepad. Any changes to be made in the settings of MSSMS??

    Regards
    Prashant
    Last edited by prashant12se; 10-21-2008 at 01:10 AM.
    Reply With Quote Reply With Quote
  9. 10-21-2008, 01:05 AM #9
    prashant12se
    prashant12se is offline Registered User
    Join Date
    Oct 2008
    Posts
    22
    Hi rmiao,
    have already tried the right click option on the .sql file, but it still opens in notepad..
    Last edited by prashant12se; 10-21-2008 at 01:07 AM.
    Reply With Quote Reply With Quote
  10. 10-21-2008, 09:23 AM #10
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Not sure why all those didn't work on your pc. Anyway, you can open .sql file inside ssms.
    Reply With Quote Reply With Quote
  11. 10-21-2008, 04:48 PM #11
    Island1
    Island1 is offline DBJ Author
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    Another Option ...

    And you could always open the file in notepad, etc., and cut and paste it to the Editor - then save the script among the RDBMS objects collection, etc.

    Good Luck ...

    Bill
    Reply With Quote Reply With Quote
  12. 10-22-2008, 12:19 AM #12
    prashant12se
    prashant12se is offline Registered User
    Join Date
    Oct 2008
    Posts
    22
    Hi All,
    the .sql file opens in MSSMS using notepad but the contents of the notepad are non-readable characters, so no use of copy-paste to the new query window. I couldn't found anythings as such to rectify this. Maybe there must be some settings to be done in MSSMS.
    Reply With Quote Reply With Quote
  13. 10-22-2008, 10:01 AM #13
    Island1
    Island1 is offline DBJ Author
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    Can You Read the Text in NotePad?

    I thought you said you could open the file in Notepad in one of your earliest posts - and assume you can read it there. If so, can't you cut and paste it - from Notepad?

    BTW, I mean the Windows Notepad - good old Notepad.exe ...

    Thanks.

    Bill
    Reply With Quote Reply With Quote
  14. 10-22-2008, 03:42 PM #14
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    >> the contents of the notepad are non-readable characters

    Is it really a sql script for sql server?
    Reply With Quote Reply With Quote
  15. 10-23-2008, 04:55 AM #15
    prashant12se
    prashant12se is offline Registered User
    Join Date
    Oct 2008
    Posts
    22
    Hi, yes it's a .sql file..
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules