Hi
Try This...
Before Do this Operation take your Data Base Backup :-)
SELECT 'ALTER TABLE '+OBJECT_NAME(C.ID) + ' ALTER COLUMN '+C.Name +' New_DataType'
FROM syscolumns C
INNER JOIN sys.tables T ON T.object_id=C.ID
WHERE C.NAME = 'LastModifiedByUserID'
Regards,
GVPrabu