Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Not able to open TSQL scripts in SSMS Expand / Collapse
Author
Message
Posted Sunday, October 20, 2013 8:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 29, 2014 1:26 PM
Points: 55, Visits: 200
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

Thanks
Shashi
Post #1506474
Posted Sunday, October 20, 2013 9:02 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:09 AM
Points: 1,913, Visits: 19,470
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
Post #1506475
Posted Sunday, October 20, 2013 9:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 29, 2014 1:26 PM
Points: 55, Visits: 200
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.
Post #1506478
Posted Sunday, October 20, 2013 9:51 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:09 AM
Points: 1,913, Visits: 19,470
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
Post #1506480
Posted Sunday, October 20, 2013 9:51 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:35 PM
Points: 6,829, Visits: 13,291
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
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #1506481
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse