sql server mseq: Is there a way to determine the sort and collation

The system store procedure sp_helpsort will tell you this.

Bart
------------
Bart Duncan
Microsoft SQL Server Support

Please reply to the newsgroup only - thanks.

This posting is provided "AS IS" with no warranties, and confers no
rights.



--------------------
Content-Class: urn:content-classes:message
From: <anonymous@discussions.microsoft.com>
Sender: <anonymous@discussions.microsoft.com>
Subject: Sort and Collation Settings
Date: Tue, 16 Dec 2003 12:41:40 -0800
Lines: 2
Message-ID: <041e01c3c415$0243a210$a101280a@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcPEFQJDJWVac9VFSBaal2pn+0c+AA==
Newsgroups: microsoft.public.sqlserver.mseq
Path: cpmsftngxa07.phx.gbl
Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.mseq:5641
NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
X-Tomcat-NG: microsoft.public.sqlserver.mseq

Is there a way to determine the sort and collation
settings that are configured on a SQL7 Server?