StoredProc written in 2000, running in 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

StoredProc written in 2000, running in 2005

Hello All My SP’s seem to have become case sensitive, with regard to fields in tables and table names, not a great problem, just edit such (in the SP).
How do I trace my SP’s?
I can execute them, but not trace them. Regards
Stephen.
Upgrade should not cuase your tables to change the collation…
Check the sys.columns view what are the table/columns has what collation… select object_name(object_id) tablename, name as columnName,
collation_name from sys.columns MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

Have you checked the collation & sort order of 2000 and 2005 server instances in thsi case?
Also what kind of upgrade path you have chosen?
[quote user="sjanp"]Hello All My SP’s seem to have become case sensitive, with regard to fields in tables and table names, not a great problem, just edit such (in the SP).
How do I trace my SP’s?
I can execute them, but not trace them. Regards
Stephen.[/quote]

]]>