SQL Server Performance

Access Denied

Discussion in 'SQL Server 2005 General Developer Questions' started by amitm79, Aug 10, 2006.

  1. amitm79 New Member

    Hi All,

    I wrote a batch (.sql file) in SQL Server 2005 Managment Studio and saved it. When i am trying to open it in any other editor (like Notepad), i am getting error message saying "Access Denied". Can anybody tell me why is it happening and how to overcome it? It used to be okay in SQL Server 2000

    Amit
  2. dineshasanka Moderator

    bit strage?

    is this happening for all the .sql files you are saving or for a one particular file

    ----------------------------------------

  3. amitm79 New Member

    All .sql files in that folder. Some of them were not even created by SQL Server 2005 management studio. It is really horrible.

    Amit
  4. dineshasanka Moderator

    is it in a network folder?- if so check user permission.



    ----------------------------------------

  5. satya Moderator

    When you're trying to open them on notepad or other editor, are they opened by SSMS?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  6. amitm79 New Member

    Yeah the files could be opened through SSMS but not through notepad.

    As i was not able to use other editors so i moved back to SQL Server 2000 QA and took the latest code from our source repository

    Amit

Share This Page