Not able to open TSQL scripts in SSMS

  • I have some TSQL scripts which ran successfully a week before and now suddenly when I open these files in SSMS its asking me to choose encoding, I am not sure what to select and If I choose 'Auto- detect' from the dropdown its opening the file but the file is empty ( no code).

    When I look at these file sizes it is 256 KB for all the files, not sure what is happening , so cananyone please help me on this as these scripts are very essential for me for a deployment early next week :crying:

    Thanks

    Shashi

  • where are your scripts stored?

    can you open them in notepad from the drive?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • my scripts are on the filesystem and it opens in notepad but I don't see any code in it ,they are all empty. strange is that the filesizes is 256kb for these scripts.

  • shashi_1409 (10/20/2013)


    my scripts are on the filesystem and it opens in notepad but I don't see any code in it ,they are all empty. strange is that the filesizes is 256kb for these scripts.

    assume you mean stored as a .sql file on a network share drive?

    can you restore from backup?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • duplicate post. No replies please.

    original post: http://www.sqlservercentral.com/Forums/Topic1506446-3077-1.aspx

    @OP: Even though you don't like the answers you received so far, therer's no reason whatsoever to open a new thread for the very same issue...



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply