[help] The collation of the database CHARACTER_01_DBF not.

Results 1 to 1 of 1
  1. #1
    Apprentice tumsaaa305 is offline
    MemberRank
    Oct 2010 Join Date
    15Posts

    ! [help] The collation of the database CHARACTER_01_DBF not.

    Code:
    TITLE: Microsoft SQL Server Management Studio Express
    ------------------------------
    
    Alter failed for Database 'CHARACTER_01_DBF'.  (Microsoft.SqlServer.Express.Smo)
    
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476
    
    ------------------------------
    ADDITIONAL INFORMATION:
    
    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
    
    ------------------------------
    
    The object 'fn_item2row' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.
    ALTER DATABASE failed. The default collation of database 'CHARACTER_01_DBF' cannot be set to Thai_CI_AS. (Microsoft SQL Server, Error: 5075)
    
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=5075&LinkId=20476
    
    ------------------------------
    BUTTONS:
    
    OK
    ------------------------------
    If the Edit.
    I'll be able to create characters of Thai names.




Advertisement