If you are having Problems getting the numeric colum types to behave well with YII you can the exactType function in framework/db/schema/mssql/CMssqlSchema.php
to *******************
protected function extractType($dbType)
{
if(strpos($dbType,'float')!==false || strpos($dbType,'real')!==false)
$this->type='double';
elseif(strpos($dbType,'bigint')===false && (strpos($dbType,'int')!==false || strpos($dbType,'smallint')!==false || strpos($dbType,'tinyint')))
$this->type='integer';
elseif(strpos($dbType,'bit')!==false)
$this->type='boolean';
elseif(strpos($dbType,'numeric')!==false)
$this->type='double';
else
$this->type='string';
}