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 21, 2013 11:03 AM
Points: 52, Visits: 187
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 @ 12:11 PM
Points: 1,886, Visits: 18,535
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 !
__________________________________________________________________
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 21, 2013 11:03 AM
Points: 52, Visits: 187
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 @ 12:11 PM
Points: 1,886, Visits: 18,535
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 !
__________________________________________________________________
Post #1506480
Posted Sunday, October 20, 2013 9:51 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:25 PM
Points: 7,040, Visits: 12,956
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