downgrade SQL2005 to SQL2k - Unicode ANSI issue

[candide_sh]

Hello,

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ührungszeic hen vor der Zeichenfolge '�퉊䘒
'.
It meens - translated from german- 'opening quote before string
<blabla>'

In the sript it stops at this line:
EXEC dbo.sp_addexten dedproperty @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?

thanks
candide_sh

[Erland Sommarskog]

(ca********@yah oo.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ührungszeich en vor der Zeichenfolge '????
'.
It meens - translated from german- 'opening quote before string
<blabla>'

In the sript it stops at this line:
EXEC dbo.sp_addexten dedproperty @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, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[candide_sh]

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.

--
candide_sh

On 26 Jan., 14:36, Erland Sommarskog <esq...@sommars kog.sewrote:

(candide...@yah oo.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ührungszeich en vor der Zeichenfolge '????
'.
It meens - translated from german- 'opening quote before string
<blabla>'

In the sript it stops at this line:
EXEC dbo.sp_addexten dedproperty @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 isunknown

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, esq...@sommarsk og.se

Books Online for SQL Server 2005 athttp://www.microsoft.c om/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.c om/sql/prodinfo/previousversion s/books.mspx- Zitierten Text ausblenden -- Zitierten Text anzeigen -

[Erland Sommarskog]

(ca********@yah oo.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, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[candide_sh]

hello Erland

the GUID-value was created by the upsizing wizard of MS-Access2003 and
I really don't know what for it is. But the conservative way is to not
touch the values created by this wizard. As the script generated by DB
Pub wizard crashed at only this one GUID-value (others worked fine) I
commented this line out and manually copy/pasted this value. Well
done...
On 26 Jan., 23:42, Erland Sommarskog <esq...@sommars kog.sewrote:

(candide...@yah oo.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 doesindeed 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, esq...@sommarsk og.se

Books Online for SQL Server 2005 athttp://www.microsoft.c om/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.c om/sql/prodinfo/previousversion s/books.mspx