SQL Server Discovery

Better, faster, cheaper ...pick two.
posts - 13, comments - 80, trackbacks - 0

Monday, April 19, 2010

SQL Server 2008 - Management Studio issue

This is a known issue with SQL Server 2008, that certain DDL operations like ALTERing a column datatype using Management Studio GUI fails.

For example, in Object Explorer, navigate to a table column > right-click on column > Modify. Change column datatype or length, then save and this error message displays:

 photo cantsavecolaltererror_zps286006e7.png

 
To workaround this problem, go to Query Editor and issue the following DDL statement instead:

ALTER TABLE dbo.FTPFile ALTER COLUMN CmdLine VARCHAR (100) ;

GO
 

The column change is successfuly applied now.

posted @ Monday, April 19, 2010 12:51 PM | Feedback (6) |

Powered by:
Powered By Subtext Powered By ASP.NET