Posted by Erland Sommarskog on 01/26/07 13:36

(candide_sh@yahoo.de) writes:
> I created a script with database publishing wizard to convert a SS2005
> db into a SS2k db. The script has schema and data and looks very good.
> When I try to start the created script in SS2k-Query analyzer, I get an
> error like (in german)
>
> Server: Nachr.-Nr. 105, Schweregrad 15, Status 1, Zeile 2
> Öffnendes Anführungszeichen vor der Zeichenfolge '????
> '.
> It meens - translated from german- 'opening quote before string
><blabla>'
>
> In the sript it stops at this line:
> EXEC dbo.sp_addextendedproperty @name=N'GUID', @value=N'????
>
> In the script many lines before I have many other GUIDs which QA
> doesn't complain, so it's an Unicode/ANSI-issue I guess. What to do
> now?

"Database publishing wizard" I will have to admit that this tool is unknown
to me. Do you mean the scripting wizard in Management Studio, or do you mean
a third-party tool?

In any case, the Open File dialog in QA has a File Format combo where you
can specify Unicode format. Normally QA (as many other Windows) tools
determines whether a file is Unicode or not by looking for a byte-order
mark in the beginning of the file. But some tools do not generate a byte-
order mark.




--
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]