Step 1
Alter Table <Table Name>Alter Column <Column Name> <New Data Type with Size>
Note : If you find any error of transaction log file the please Run This Query
ALTER DATABASE <DataBase Name>
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE (DataBase Name_log, 1);
GO
sp_helpdb <DataBase Name>
GO
ALTER DATABASE <DataBase Name>
SET RECOVERY FULL
GO
Please Use again Step 1
0 comments:
Post a Comment