setuser 'dbo' GO /* Sunday, 27 June 2010 16:19:00 User: Server: SERVER Database: TBSdata Application: SQL Server Enterprise Manager*/ BEGIN TRANSACTION SET QUOTED_IDENTIFIER ON GO SET TRANSACTION ISOLATION LEVEL SERIALIZABLE GO COMMIT BEGIN TRANSACTION SET IDENTITY_INSERT dbo.tPerson OFF GO ALTER TABLE tPerson DELETE EmailAddress GO ALTER TABLE tPerson ADD EmailAddress varchar(255) NULL GO COMMIT