Collation in table-variable declaration 1

[MarnickBolle]

Why does this syntax:

DECLARE @tblTabel TABLE (field1 varchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL)

used in a stored procedure is accepted on one SQL-server and not accepted on another one while both SQL-servers are SQL2000-servers SP3?

What can be the reason and is there a solution for this problem, so that the syntax is accepted on all SQL2000-servers.

 

[vongrunt]

The only thing that comes to my mind is database compatibility level (must be 80).

 

[MarnickBolle]

Vongrunt,

That was the solution.
Thank you so much!!!!!