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).The collation showed up after closing enterprise manager and then going back in.
Showing posts with label restore. Show all posts
Showing posts with label restore. Show all posts
Friday, March 9, 2012
Subscribe to:
Posts (Atom)