"Enric" wrote:

> Dear fellows,
>
> I would like to know how do I figure out which collation is established in a
> DB created in a Sql Server 7.0. I need to migrate to 2000 but I don't know
> how to see this information.
> Any input would be much appreciated.
> Regards,

"Enric" <En***@discussions.microsoft.com> wrote in message
news:45C1531C-243B-4487-8A00-0FEBA3556744@microsoft.com...
> sp_helpserver provide info but not that
>
> "Enric" wrote:
>
>> Dear fellows,
>>
>> I would like to know how do I figure out which collation is established
>> in a
>> DB created in a Sql Server 7.0. I need to migrate to 2000 but I don't
>> know
>> how to see this information.
>> Any input would be much appreciated.
>> Regards,

"Aaron Bertrand [SQL Server MVP]" wrote:

> Of course not, because collation is a database property, not a server
> property.
>
> You can parse the results from sp_helpdb or you can use:
>
> SELECT DATABASEPROPERTYEX('database_name','Collation');
>
>
>
>
>
> "Enric" <En***@discussions.microsoft.com> wrote in message
> news:45C1531C-243B-4487-8A00-0FEBA3556744@microsoft.com...
> > sp_helpserver provide info but not that
> >
> > "Enric" wrote:
> >
> >> Dear fellows,
> >>
> >> I would like to know how do I figure out which collation is established
> >> in a
> >> DB created in a Sql Server 7.0. I need to migrate to 2000 but I don't
> >> know
> >> how to see this information.
> >> Any input would be much appreciated.
> >> Regards,
>
>
>