Posted by ZeldorBlat on 03/10/06 16:50

Dil wrote:
> 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

Here's something you can try:

Remove all the SET statements
Run the script
See what happens

• Next in forum: Linked Server via ODBC and stored procedure
• Prev in forum: Re: dbcc shrinkfile - SQL Server 2000 - invalidate log?
• Thread view: Re: Too Many SET Options

[Reply to this message]