MS SQL Server - Re: Sql 2000 to Sql 2005 migration error

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Sql 2000 to Sql 2005 migration error - Must declare the scalar

Steen Persson (DK)

2006-03-28, 3:23 am

Tom Moreau wrote:
> Basically, a new DB will take the default collation of your server - unless
> you explicitly specify it:
>
> CREATE DATABASE MyOptionsTest
> SQL_Latin1_General_C
P1_CI_AS
>
> This way, you're guaranteed to get the correct collatioin when you create
> the DB.
>
What about using the COLLATE clause in the SP? Wouldn't that do the trick?

Regards
Steen

Sponsored Links