November 18, 2009 at 6:04 am
how to find the collation of a database.how can we migrate this databse to another server with default collation different
November 18, 2009 at 6:46 am
Use the Following T-SQL Command
SELECT DATABASEPROPERTYEX('DBNAME', 'Collation') SQLCollation;
You can also right click on the database select properties. In the general page of the Properties window, the last property is Collation.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 18, 2009 at 6:49 am
To copy the data, you need to create the new database with desired collation and use Import/Export wizard to copy the data onto that database (be it local or Remote Server)
This is a one time work, so I do not recommend creating SSIS Package.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 18, 2009 at 6:57 am
Bru Medishetty (11/18/2009)
Use the Following T-SQL Command
SELECT DATABASEPROPERTYEX('DBNAME', 'Collation') SQLCollation;You can also right click on the database select properties. In the general page of the Properties window, the last property is Collation.
i am using sql server2000
November 18, 2009 at 7:00 am
shanila_minnu (11/18/2009)
Bru Medishetty (11/18/2009)
Use the Following T-SQL Command
SELECT DATABASEPROPERTYEX('DBNAME', 'Collation') SQLCollation;You can also right click on the database select properties. In the general page of the Properties window, the last property is Collation.
i am using sql server2000
So what? :unsure:
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply