asim

How can I change the Sort Code Page under MSDE? And also
where can i find the rebuild option under MSDE?

Any help would be highly appreciated

Thanks

andrea montanari

hi Asim,
"Asim" <anonymous@discussions.microsoft.com> ha scritto nel messaggio
news:20a001c47d51$d5771270$a301280a@phx.gbl...

you can create databases with different collations, and you can define
different collation at column level too...
as regard the defaul collation, I think MSDE does not provide the rubuild
utility, so you probably have to uninstall MSDE and reinstall it
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

asim

HI Andrea,

Thanks for your quick response. As I am new to this, can
you please guide me how to determine the collation for the
database in msde.

Thanks once again

Asim

nel messaggio

you can define


provide the rubuild

reinstall it

http://italy.mvps.org


MSDE 2000 a visual

andrea montanari

hi Asim,
"Asim" <anonymous@discussions.microsoft.com> ha scritto nel messaggio
news:247501c47d58$fc457160$a601280a@phx.gbl...


you can investigate the collation settings like
SET NOCOUNT ON
SELECT SERVERPROPERTY ( 'Collation' ) AS [Server wide Collation] ,
DATABASEPROPERTYEX ( 'master' , 'Collation' ) AS [Specific Database
Collation] ;
as for the specifi instance and for each database...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply