Results 1 to 4 of 4

Thread: Change default Collation ?

  1. 10-23-2003, 05:25 AM #1
    oddoren
    oddoren is offline Registered User
    Join Date
    Sep 2002
    Posts
    13

    Question Change default Collation ?

    SQL Server 2000: Is it possible to change SQL server's default collation without reinstall ?
    Reply With Quote Reply With Quote
  2. 10-23-2003, 06:15 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Rebuild Master.
    Reply With Quote Reply With Quote
  3. 10-23-2003, 06:16 AM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    but why you need to do that? In SQL 2000 you can specify collation for database, table and even columns.
    Reply With Quote Reply With Quote
  4. 10-23-2003, 06:35 AM #4
    oddoren
    oddoren is offline Registered User
    Join Date
    Sep 2002
    Posts
    13
    Thanks MAK.
    Yes, I know you can specify collation. But some SW vendors uses server's default (in automated scripts not editable by us..) when creating databases, and then dbs get incompatible.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules