Prev: SQL Standards
Next: Log backup file is larger than the .ldf file
From: cbrichards via SQLMonster.com on 5 May 2010 18:25
I have tested with both ANSI_WARNINGS ON and OFF. If I expand the Views
folder, there are not any views on this table, let alone an indexed view.
There are not any computed columns on the table. There is a unique identifier
data type on one column, but all the other columns are of int or varchar.
There are not any filtered indexes or spacial indexes, either.

Kalen Delaney wrote:
>Are you sure you're checking the session where you are issuing the ALTER
>TABLE?
>Are you sure you tested the ALTER when the SESSION option was off?
>You might consider running a trace to see where the setting is getting
>changed.
>Is there any chance you have an indexed view or a computed column on the
>table?
>
>(FYI, sys.dm_exec_sessions is not a catalog view, it is a Dynamic Management
>View)
>> The catalog view sys.dm_exec_sessions also shows that ANSI_WARNINGS = 1.
>> Therefore, I get the same error message whether ANSI_WARNINGS is ON or
>[quoted text clipped - 18 lines]
>>>>
>>>> How can I successfully change the column from int to bigint?

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201005/1

First  |  Prev  | 
Pages: 1 2
Prev: SQL Standards
Next: Log backup file is larger than the .ldf file