Posted by Dil on 03/10/06 15:52

Hi

I have created a Sql Script through Enterprise Manager for Drop a
column. By default its creating lot of 'SET' commands. I doubt all
these SET options are required or not. Pls comment on this issue

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
ALTER TABLE Employee
DROP COLUMN OrderDetails_ID
GO
COMMIT


Dil

[Back to original message]