SQL Setting Command

[no-spam]

Hi


Is there a sp command I can issue which will show me what the "sort
order" etc for my MSsql server.

I need to re-install it, but need to record what custom setting it has
if any before I wipe it.

I have to reinstall to reconfigure the RAID arry under it

Thanks

[Simon Hayes]

Re: SQL Setting Command


"no-spam bhfshops.org.uk " <rc@> wrote in message
news:3f93ff77.5 42308618@news.d emon.co.uk...[color=blue]
> Hi
>
>
> Is there a sp command I can issue which will show me what the "sort
> order" etc for my MSsql server.
>
> I need to re-install it, but need to record what custom setting it has
> if any before I wipe it.
>
> I have to reinstall to reconfigure the RAID arry under it
>
> Thanks
>
>
>
>[/color]

That depends on the version:

/* All versions */
exec sp_helpsort

/* SQL2000 only */
select serverproperty( 'Collation')
select databasepropert yex('Collation' )

Simon