Re: Unicode encoding with SQL Management Studio

Tom Huguelet (tomhug@xxxxxxxxxxxxxxxxx) writes:
We have an environment that is a mixture of SQL 2000 and 2005. Most of
my developers are switching over to use SQL Management Studio for both
SQL 2005 and SQL 2000 (Relational Engine).

We also use Visual Source Safe 6.0 for source code control. We're
encountering problems with SQL Management Studio re-encoding documents
to Unicode. We still need to retain backwards compatibility with VSS
6.0 and with the SQL 2000 tools.

The SQL 2000 tools can read Unicode files.

And as Paul Shapiro said, so can SourceSafe 2005. What I like to add is
that VSS 2005 is compatible with VSS 6. You probably need VSS 2005 to
Add and Check in the file, or else it gets listed as binary. But VSS 6
can still read the database, as the format for the SoruceSafe database
hasn't changed.

How can I use the SQL Management Studio but have it leave the encoding
schemes of the SQL source code files in the original form MS-DOS/Code
Page 850?

CP850? Do you like to hurt yourself? Stay away from that. Or do you need
compatibility with the 6.5 tools as well?

Any say, as Andrew said, you can use Save With Encoding to resolve this.
But I guess that if you open a CP850 file in Mgmt Studio, it will think
it's ANSI, and you will get a mess...


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: VSS event 6013
    ... I am experiencing a similar issue where VSS tries to access my SQL ... Server every time I perform a system state backup. ...
    (microsoft.public.windows.server.sbs)
  • Re: Unicode encoding with SQL Management Studio
    ... SQL 2005 and SQL 2000. ... We also use Visual Source Safe 6.0 for source code control. ... We still need to retain backwards compatibility with VSS ...
    (microsoft.public.sqlserver.tools)
  • Re: VSS corruption on SBS2003 R2 Premium
    ... REM re-register VSS ... regsvr32 /i swprv.dll ... REM Re-register SQL .dll file ... echo Run list writers command ...
    (microsoft.public.windows.server.sbs)
  • Re: How VSS Works with NTBackup
    ... I can't point you to a document, but my understanding is that SQL 2000 + SPx ... VSS interaction is now integrated into SQL Server so VSS can request SQL ... updates until VSS is able to take a db snapshot. ... a consistent backup of a running system. ...
    (microsoft.public.windows.server.sbs)
  • Re: EventLog Fehler 6013
    ... >Im Windows Event Log auf meinem SQL Server erscheint folgende Fehlermeldung: ... >Bringt der Patch in meiner Situation was??? ... auf SQL-Server oder Exchange-Server gewisse Prozesse ... Das Problem bei uns beiden ist, daß der VSS unter "localsystem" läuft ...
    (microsoft.public.de.sqlserver)
Loading