Post reply

Collation settings

  • March 16, 2013 at 12:53 am

    #271668

    Hi all,

    Today i found that my reporting database and reporting tempdb are in different collation rom the normal databases. Can databases in a instance be in different collations .

  • March 16, 2013 at 12:54 am

    #1597788

    Yes.

  • March 16, 2013 at 12:57 am

    #1597789

    If two databases in a instance are in different collation . Can we implement replication in between them and any other tasks related to those databases.

  • March 16, 2013 at 2:46 am

    #1597791

    Replication between two databases on the same instance? Not sure why you'd want to do that, but collation doesn't prevent that, or any other SQL feature from working.

    You can have 2 tables in the same DB with different collations. Hell, you can have 2 columns in the same table with different collations.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 16, 2013 at 3:07 am

    #1597792

    Thanks Gail...

Viewing 5 posts - 1 through 4 (of 4 total)

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