Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)

  • RE: How to change SQL Server Collation

    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...

  • RE: How to change SQL Server Collation

    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...

  • RE: How to change SQL Server Collation

    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...

  • RE: How to change SQL Server Collation

    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...

  • RE: How to change SQL Server Collation

    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...

  • RE: How to change SQL Server Collation

    paul_shears (12/17/2009)


    Thanks

    I 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...

  • RE: How to change SQL Server Collation

    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...

  • RE: How to change SQL Server Collation

    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...

  • RE: How to change SQL Server Collation

    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...

  • RE: How to change SQL Server Collation

    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...

  • RE: Must declare the scalar variable "@name". SQL server 2005

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

Viewing 11 posts - 1 through 11 (of 11 total)