Michael Meierruth (11/17/2010)

---

du.pereira (11/17/2010)

---

Sure! That what it does. It will change collation of...

Sure! That what it does. It will change collation of all active databases...

Michael Meierruth (11/17/2010)

---

eduardo.pin (11/17/2010)

---

Stop the running server.

2. Open a Command Prompt and go to the SQL Server directory.

3. Type:

sqlservr -m -T4022 -T3659 -q"new collation"

Example: sqlservr -m -T4022 -T3659 -q"latin1_general_ci_ai"

I...

Hello Atul,

This is strange. Are you using SQL 2005? I used this command last week on one of our development databases which was incorrectly installed and worked fine. The server...

paul_shears (12/17/2009)

---

Thanks.

My alternative method, was to back up/export the user databases, delete the instance, create a new instance with the correct collation and then re-create/import the databases.

Does your method achieve...

Leave only the databases that you...

Hi Paul.

You must detach your user databases, I don't think taking them offline will work, you have to test it to make sure.

There is nothing else required, not that I...

Hello does anyone know what flag 3659 does? I know that -m is single user; -T4022 bypass automatically started processes. But unsure what 3659 is used for here, as I...

Sunil, I found this on a Brazilian DBA forum. It was very hard to find (almost hidden), and I tried to find the link for it, but I couldn't. I...

I had the same issue for a long time with no avail. I didn't find the reinstall command useful and the alter database didn't help since it didn't change the...

Couldn't you just go to database properties > options and select the right collation?