SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Having problem openning SQL scripts


Having problem openning SQL scripts

Author
Message
shashi_1409
shashi_1409
SSC Journeyman
SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)

Group: General Forum Members
Points: 97 Visits: 216
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
sqlsurfing
sqlsurfing
Old Hand
Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)

Group: General Forum Members
Points: 392 Visits: 1185
shashi_1409 (10/20/2013)
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




Have you tried opening your TSQL Scripts in notepad to see if it is view able?

--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully :-D
LutzM
LutzM
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10499 Visits: 13559
If those files are on a network share, ask your admin responsibe for that share if a backup from last week is available and if they're able to restore the files in question. If tose files are gone then I think you'll need to rewrite the code.



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
shashi_1409
shashi_1409
SSC Journeyman
SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)

Group: General Forum Members
Points: 97 Visits: 216
I have tried openning the file in notepad and it didnt work...any help how to address this issue is greatly appreciated.
ramesh_iitd
ramesh_iitd
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 21
Pls open ur scripts file and see what is showing ur encoding "dropdown".Please make sure it is "ANSI".If not then save the fille with "ANSI" encoding type and they try to open from SSMS.
Bhuvnesh
Bhuvnesh
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5354 Visits: 4076
do that files contain INSERT statements ? with N' characters

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
shashi_1409
shashi_1409
SSC Journeyman
SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)

Group: General Forum Members
Points: 97 Visits: 216
Ramesh, when you said open the files and check encoding , do you mean opening it in notepad and check the encoding( I checked and it is ANSI).

Thanks
Shashi
shashi_1409
shashi_1409
SSC Journeyman
SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)

Group: General Forum Members
Points: 97 Visits: 216
Bhuvnesh, It has inserts and update statements in it.

Thanks
Shashi
Bhuvnesh
Bhuvnesh
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5354 Visits: 4076
shashi_1409 (10/21/2013)
Bhuvnesh, It has inserts and update statements in it.

Thanks
Shashi
so my guess is .. there might be some uni code sitting (international languages..)

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search