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, October 13, 2014 2:21 PM
Points: 55, Visits: 201
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 @ 2:28 PM
Points: 1,932, Visits: 19,937
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, October 13, 2014 2:21 PM
Points: 55, Visits: 201
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 @ 2:28 PM
Points: 1,932, Visits: 19,937
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: Thursday, November 13, 2014 9:47 AM
Points: 6,842, Visits: 13,368
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