Post reply

Database upgarde from SQL 2000 to SQL 2005

  • July 28, 2011 at 9:20 am

    #245057

    I've upgraded a database from SQL 2000 to SQL 2005

    When I run the below query on upgraded database on SQL 2005 server

    SELECT DISTINCT

    collation

    FROM syscolumns

    Output :

    Latin1_General_BIN

    Latin1_General_CI_AS_KS_WS

    SQL_Latin1_General_CP1_CI_AS

    I've run the same query on SQL 2000 and the output is as below

    Latin1_General_CI_AS

    Does that mean SQL 2000 is not showing other collations when the query is run?

    why there is a collation difference?

    Thanks

  • July 28, 2011 at 3:56 pm

    #1360487

    Hi again Sqlsavy 😛

    Take a look at this on 2005. You may have a different view after filtering out the ms-shipped tables:

    SELECT DISTINCT

    t.name AS table_name,

    c.collation_name

    FROM sys.columns c

    JOIN sys.tables t ON c.object_id = t.object_id

    WHERE c.collation_name IS NOT NULL

    AND t.is_ms_shipped = 0

    ORDER BY c.collation_name,

    t.name ;

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • July 29, 2011 at 5:22 am

    #1360676

    Thanks SSCrazy

    Apparently different collations on SQL 2005 are of System Objects in User database.

  • July 29, 2011 at 10:11 am

    #1360912

    Sqlsavy (7/29/2011)

    Thanks SSCrazy

    Apparently different collations on SQL 2005 are of System Objects in User database.

    Apparently 🙂

    PS I have been called Crazy, but my nick is opc.three. SSCrazy is just my designation on the site based on my point total 😉

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • July 29, 2011 at 10:17 am

    #1360915

    opc.three (7/29/2011)

    Sqlsavy (7/29/2011)

    Thanks SSCrazy

    Apparently different collations on SQL 2005 are of System Objects in User database.

    Apparently 🙂

    PS I have been called Crazy, but my nick is opc.three. SSCrazy is just my designation on the site based on my point total 😉

    But he's crazy so no mistake here! :hehe:

    And not I'm not a coach :-D.

  • July 29, 2011 at 10:26 am

    #1360926

    Ninja's_RGR'us (7/29/2011)

    opc.three (7/29/2011)

    Sqlsavy (7/29/2011)

    Thanks SSCrazy

    Apparently different collations on SQL 2005 are of System Objects in User database.

    Apparently 🙂

    PS I have been called Crazy, but my nick is opc.three. SSCrazy is just my designation on the site based on my point total 😉

    But he's crazy so no mistake here! :hehe:

    And not I'm not a coach :-D.

    What's that saying about the pot and the kettle? 😛

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • July 29, 2011 at 10:28 am

    #1360929

    Never heard of it :Whistling:

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply