CREATE DATABASE failed. COLLATE clause cannot be used with the FOR ATTACH option.

Details
Product: SQL Server
Event ID: 1812
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: CREATE DATABASE failed. COLLATE clause cannot be used with the FOR ATTACH option.
   
Explanation
Your CREATE DATABASE statement included both the COLLATE clause and the FOR ATTACH option. These options cannot be used together in a CREATE DATABASE statement. When you use the FOR ATTACH option, you are attaching existing database files, and the COLLATION of those files will be applied to the new database.
   
User Action
Do not specify both the COLLATE clause and the FOR ATTACH option in the CREATE DATABASE statement. If you need to change the collation of the database you attached, follow the instructions in Microsoft Knowledge Base article 325335.

Related:

Leave a Reply