« February 2007 | Main | April 2007 »
March 20, 2007
Column Datatypes on Partitioned Tables
We have been having major problems with corrupted data in our SQL server databases for the last few weeks and have finally found the issue. It seems that SQL Server 2005 does not support altering the datatype of a column in a partitioned table. This is documented in books on-line in one small statement in the Alter Table topic:Additionally, you cannot change the data type of a column of a partitioned table.
However, running the ALTER statement produces NO ERRORS or WARNINGS at all!!!!
---from Dave Frommer, Senior Software Engineer, RDA Corporation
Share:
Posted by Steve Mann at 11:32 AM | Comments (0)
