Microsoft SQL Server Error 5030

So, if you are trying to change the collation of a database and getting error 5030, this is much likely because you cannot change the collation of a database when it is in Multi_User mode. In this case, you should try to run the following query.

-- the following line sets the database to "Single User" mode
ALTER DATABASE DBNAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE
-- the following line sets the new collation
ALTER DATABASE DBNAME COLLATE COLLATIONNAME
-- the following line sets the database back to "Multi User" mode
ALTER DATABASE DBNAME SET MULTI_USER

DBNAME: Database name
COLLATIONNAME: New collation’s name. E.g.: Latin1_General_CI_AI

You may also like...

13 Responses

  1. thanks for good content that work for change collation in database

  2. navid says:

    tanx very much

  3. Potenzmedizin Osterreich says:

    Vielen Dank.
    Fritz aus Wien.

  4. Leticia says:

    Worked properly, tks a lot!

  5. razi says:

    It solved my problem
    Thanks millions!

  6. Manos says:

    Worked for me too. Thank you very much!

  7. Spyros says:

    Thank you worked like a charm !!!!!

  8. suneeta says:

    thanq so much it wrk out for me

  9. v-najian_iran says:

    thnx alot

  10. Boby says:

    Thanks, it worked, you are amazing! ;-)

  11. Virag Desai says:

    Thanks a tons !! This worked like a charm for me !!

  12. Rakesh Patil says:

    Thank you very much, it helps to change collation successfully ………

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>