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.

Thanks

Answers


Upgrading to SQL Server 2005 SP2 fixes this issue. Apparently there was no bug ever raised for this.

Thanks


Need Your Help

Float returning exponential notation

java xpath

I'm writing a bit of code for use in an Xpath query which is causing a problem. I'm trying to read a random name from a list, however the float (x) occasionally returns exponential notation.

Do exceptions break encapsulation?

exception-handling encapsulation

In the first place, a class or library is created when you do not want to worry about the details of an implementation, but then you need to know the inner workings of the class to properly handle ...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.