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

Posted by candide_sh on 01/26/07 13:13

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

thanks
candide_sh

 

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

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