I have old .prc files (SQL Server Stored Procedures) which have exported from SQL Server 2000. Now when I try to open a .prc file using SSMS 2008, I get a bunch of chinese characters and other odd characters. I tried a solution found here, but it did not help.
A:
Can you open the files in a regular text editor, e.g. Notepad or something??
As far as I remember, the SQL Server 2000 tools used to use ANSI / ISO-8869-1 encoding for their files, while newer Mgmt Studio version expect UTF-8 or UTF-16.
So my suggestion would be to open those *.PRC files in an editor and store them as *.SQL files using UTF-8 encoding. After that you should be able to open them in SSMS 2008 without problems.
marc_s
2010-08-13 07:26:09
Thanks, I converted to UTF-8 and thses chinese characters converted to "?". Now I can find-replace those from the file. Many thanks!
atricapilla
2010-08-13 09:10:03