October 20, 2013 at 8:40 am
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
October 20, 2013 at 9:02 am
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
October 20, 2013 at 9:39 am
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.
October 20, 2013 at 9:51 am
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
October 20, 2013 at 9:51 am
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...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply