Viewing 11 posts - 1 through 11 (of 11 total)
Michael Meierruth (11/17/2010)
du.pereira (11/17/2010)
Michael Meierruth (11/17/2010)
Will the following sequence work with your magic command in place of the 'alter database' command?
Sure! That what it does. It will change collation of...
November 18, 2010 at 2:30 am
Michael Meierruth (11/17/2010)
Will the following sequence work with your magic command in place of the 'alter database' command?
Sure! That what it does. It will change collation of all active databases...
November 17, 2010 at 4:20 pm
Michael Meierruth (11/17/2010)
eduardo.pin (11/17/2010)
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...
November 17, 2010 at 9:41 am
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...
June 12, 2010 at 5:22 pm
paul_shears (12/17/2009)
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...
December 17, 2009 at 9:35 am
paul_shears (12/17/2009)
ThanksI have a user database that has been created using the default - do I leave that attached (i.e so that it is changed)?
Leave only the databases that you...
December 17, 2009 at 9:00 am
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...
December 17, 2009 at 8:42 am
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...
August 14, 2009 at 10:23 am
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...
July 15, 2009 at 6:50 am
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...
July 1, 2009 at 8:15 am
Couldn't you just go to database properties > options and select the right collation?
May 12, 2008 at 6:30 pm
Viewing 11 posts - 1 through 11 (of 11 total)