Forum Replies Created

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

  • RE: Changing Server Collation on SQL Server 2008

    Thank you again John for all the help! Do you perhaps have an email address I can forward the logs to?

  • RE: Changing Server Collation on SQL Server 2008

    No luck on the server like I had on my local instance :crying:

    Y:\>setup /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=REBUILDDATABASE /INSTANCENAME

    =MSSQLSERVER /SQLSYSADMINACCOUNTS=MyDomain\MyUsername /SAPWD=thesapassword /SQLCOL

    LATION=SQL_General_CP1_CI_AS

    Microsoft (R) SQL Server 2008 R2 Setup 10.50.1600.01

    Copyright (c) Microsoft Corporation....

  • RE: Changing Server Collation on SQL Server 2008

    Perfect! Thanks. I actually just managed to make a success of it on my local machine with the script you gave me! Server Collation was changed from Latin1_General_CI_AS to Latin1_General_CI_AS_KS_WS...

  • RE: Changing Server Collation on SQL Server 2008

    Currently this is our OpsManager server. All the user DB's have been backed up and detached. So its a bare instance. SQL Version: Microsoft SQL Server 2008 (SP1) - 10.0.2531.0...

  • RE: Changing Server Collation on SQL Server 2008

    Good morning JM.

    I came across you article after trying to find a way to change or server collation for SQL Server 2008 R2 std.

    Am I right the command you...

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