SQL Server Performance

StoredProc written in 2000, running in 2005

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by sjanp, Jul 27, 2007.

  1. sjanp New Member

    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.
    sjanp, Jul 27, 2007
    #2

  2. MohammedU New Member

    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.
    MohammedU, Jul 27, 2007
    #2

  3. satya Moderator

    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]
    satya, Jul 30, 2007
    #3

Share This Page