Posted by Erland Sommarskog on 01/26/07 22:42

(candide_sh@yahoo.de) writes:
> DB Pub Wizard comes from SS2005, from Microsoft SQLServer2005 website
> (search for feature pack)
> I guess it creates a script file (myscript.sql) but doesn't create this
> file in UNICODE. I searched and played around in SS2005, but I think I
> can't influence the behaviour of DB Pub Wizard (writing only ANSI) from
> SS2005.
>
> Remember I open QA in SS2000 to start this script. Thanks for your
> hint, I found the dialog box in QA and changed the file format to
> Unicode, but no success.

I downloaded the DB Publish Wizard, and it does indeed generate a Unicode
file. I had created this table on SQL 2005:

CREATE TABLE utländsk(a nvarchar(234) NOT NULL)
go
INSERT utländsk(a) VALUES (nchar(8080) + nchar(324))

and I was able to insert that data successfully on SQL 2000 through
Query Analyzer.

Maybe there is some special catch with extended properties. (I never
use them myself, so I did not play with one.)

What is in that extended property on SQL 2005?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

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

[Back to original message]