Check Server and Database Collations

Hello,
I create one script that gives me the server and database
collations.
This server has SQL Server 2000 and there's no proble but
when i execute the script in one server with SQL Server
7.0 it doesn't work because there are two functions that
doesn't exists in SQL Server 7.0
The following functions are not working:
DATABASEPROPERTYEX('database_name', 'collation')
SERVERPROPERTY('collation')
I've seen DATABASEPROPERTY on SQL 7.0 but it has no
options for the collation.
Can anybody tell me how can i turn arround this little
problem?
I need to check Server and Database collations in this
server.
Regards
Hi,
SQL 7 do not have those properties. COllation setting in SQL 7 is server
wise not database specific.
Execute the below command to get those details.
sp_helpsort
Thanks
Hari
MCDBA
You could check the sort and charec
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:acf201c47965$7a651840$a501280a@.phx.gbl...
> Hello,
> I create one script that gives me the server and database
> collations.
> This server has SQL Server 2000 and there's no proble but
> when i execute the script in one server with SQL Server
> 7.0 it doesn't work because there are two functions that
> doesn't exists in SQL Server 7.0
> The following functions are not working:
> DATABASEPROPERTYEX('database_name', 'collation')
> SERVERPROPERTY('collation')
> I've seen DATABASEPROPERTY on SQL 7.0 but it has no
> options for the collation.
> Can anybody tell me how can i turn arround this little
> problem?
> I need to check Server and Database collations in this
> server.
> Regards
>