开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜