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?开发者_C百科 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.
Thanks
精彩评论