Alter Table Alter Column failing for resizing columns
ALTER TABLE TABLE_NAME ALTER COLUMN COLUMN_NAME
is failing while changing a column from int to bigint on SQL Server 2005 SP1 (32-bit).
The same is however passing on SQL Server 2005 SP1 (64-bit) and SQL Server 2008.
Has anyone experienced this before? Can you point me to the bug raised for this with MS or any article pointing to this?
Edit: The error message is: Possible schema corruption. Run DBCC CHECKCATALOG. Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.
Upgrading to SQL Server 2005 SP2 fixes this issue. Apparently there was no bug ever raised for this.