On 26 Jan., 14:36, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (candide...@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
> > =D6ffnendes Anf=FChrungszeichen 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=3DN'GUID', @value=3DN'????
>
> > 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 m=
ean
> 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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodt=
echnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/=

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

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

On 26 Jan., 23:42, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (candide...@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=E4ndsk(a nvarchar(234) NOT NULL)
> go
> INSERT utl=E4ndsk(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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodt=
echnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/=