MSDE Sort Page

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
hi Asim,
"Asim" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:20a001c47d51$d5771270$a301280a@.phx.gbl...
> How can I change the Sort Code Page under MSDE? And also
> where can i find the rebuild option under MSDE?
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.shtmhttp://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
|||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
>--Original Message--
>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
>.
>
|||hi Asim,
"Asim" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:247501c47d58$fc457160$a601280a@.phx.gbl...
> 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.
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.shtmhttp://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
sql