Meff rašė:
> Sveiki. SQL Server 2005. Problema tokia, kad nors duombazių
> Collationai ir sutampa - pas klientus Stored Procedūros vis tiek
> vykdomos kitaip.

http://msdn.microsoft.com/en-us/library/ms184391(SQL.90).aspx

„The collation of an identifier depends on the level at which it is 
defined. Identifiers of instance-level objects, such as logins and 
database names, are assigned the default collation of the instance. 
Identifiers of objects within a database, such as tables, views, and 
column names, are assigned the default collation of the database. For 
example, two tables with names different only in case may be created in 
a database with case-sensitive collation, but may not be created in a 
database with case-insensitive collation. For more information, see 
Identifiers.

Variables, GOTO labels, temporary stored procedures, and temporary 
tables can be created when the connection context is associated with one 
database, and then referenced when the context has been switched to 
another database. The identifiers for variables, GOTO labels, temporary 
stored procedures, and temporary tables are in the default collation of 
the instance.“


p.s. reikia palyginti abiejų serverių „SERVERPROPERTY(N'Collation')“