Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    UK
    Posts
    26

    Unanswered: NULL/Blank Collation after DB restore

    If a database's collation is blank under enterprise manager and NULL with SELECT DATABASEPROPERTYEX('<Database_Name>', 'Collation') does this mean it has the same collation as the server?

    The reason I ask is that I restored a database with a different collation to my server and so I expected the different collation name to show up.
    Its showing as blank though...
    I thought databases kept their original collation even if restored to another server.
    (The database was restored as a new database).

  2. #2
    Join Date
    Mar 2004
    Location
    UK
    Posts
    26

    Thumbs up Solved, needed restart.

    The collation showed up after closing enterprise manager and then going back in.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •