You are here: Re: downgrade SQL2005 to SQL2k - Unicode ANSI issue « MsSQL Server « IT news, forums, messages
Re: downgrade SQL2005 to SQL2k - Unicode ANSI issue

Posted by candide_sh on 01/26/07 14:34

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...@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
> > Ö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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Zitierten Text ausblenden -- Zitierten Text anzeigen -

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация