Msg 1505, Level 16, State 1, Line 1

The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.sysschobjs' and the index name 'nc1′. The duplicate key value is (0, 1, person).

Msg 5072, Level 16, State 1, Line 1

ALTER DATABASE failed. The default collation of database 'TestCollationChange' cannot be set to SQL_Latin1_General_CP1_CI_AS.

CREATE DATABASE [TestCollationChange]

ON PRIMARY

( NAME = N'TestCollationChange', FILENAME = N'C:\SQL_Data\TestCollationChange.mdf')

LOG ON

( NAME = N'TestCollationChange_log', FILENAME = N'C:\SQL_Data\TestCollationChange_log.ldf')

COLLATE Latin1_General_BIN;

GO

USE [TestCollationChange];

GO

CREATE TABLE dbo.Person

(RowID int NOT NULL IDENTITY (1, 1),

FirstName varchar(30) NOT NULL,

LastName varchar(30) NOT NULL);

GO

ALTER TABLE dbo.Person ADD CONSTRAINT PK_Person PRIMARY KEY CLUSTERED (RowID);

GO

CREATE TABLE dbo.person

(RowID int NOT NULL IDENTITY (1, 1),

FirstName varchar(30) NOT NULL,

LastName varchar(30) NOT NULL);

GO

ALTER TABLE dbo.person ADD CONSTRAINT PK_person PRIMARY KEY CLUSTERED (RowID);

GO

ALTER DATABASE [TestCollationChange] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

ALTER DATABASE [TestCollationChange] COLLATE SQL_Latin1_General_CP1_CI_AS;

SELECT * FROM sys.objects where name = 'person';

SELECT * FROM sys.objects where name COLLATE SQL_Latin1_General_CP1_CI_AS = 'person';