sql server msde: We have an application running on SQL-Server and now we want to have another
verison for MSDE. But I could not install it successfully. According to
some articles I know that there would have problem to install MSDE on
Chinese Version (Hongkong) Windows XP. Could someone help to tell me any
solution for this issue.

And, can I use the Enterprises manager to manage the MSDE? And how can I
know any MSDE is running on the PC?

Many Thanks!!!!!

hi,
"BBC1009" <bevis168@yahoo.com.hk> ha scritto nel messaggio
news:%235n7vqu7EHA.3836@tk2msftngp13.phx.gbl
[quoted text, click to view]

try changing your Windows collation before installing MSDE to one of the
"supported" SQL Server Windows collations

[quoted text, click to view]

you are not allowed to use Enterprise Manager, Query Analyzer and so on, on
MSDE solutions... you have to rely on home built tools or third party
solutions... please have a look at
http://www.microsoft.com/sql/msde/partners/default.asp ,
http://www.aspfaq.com/show.asp?id=2442 for some of them, both free and
commercial... google for further..

in order to know if you are connected to MSDE instances, you can query for
SET NOCOUNT ON
SELECT SERVERPROPERTY( 'Edition' ) AS [Edition]

which returns, for MSDE,
Edition
---------------
Desktop Engine

--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply