SELECT  obj.name AS TableName, col.name AS ColName, col.xtype,       col.lengthinto #tmp1FROM eShipping_New_QA_User_1_BackUp.dbo.syscolumns col INNER JOIN      eShipping_New_QA_User_1_BackUp.dbo.sysobjects obj ON col.id = obj.idORDER BY obj.nameSELECT  obj.name AS TableName, col.name AS ColName, col.xtype,       col.lengthinto #tmp2FROM eShipping_20140805.dbo.syscolumns col INNER JOIN      eShipping_20140805.dbo.sysobjects obj ON col.id = obj.idORDER BY obj.nameselect  tablename,colname,0 as xtypeold,0 as lengthold,0 as xtypenew,0 as lengthnewinto #tmp3from (select tablename,colname from #tmp1 union select tablename,colname from #tmp2)bupdate #tmp3 set xtypeold=#tmp1.xtype,lengthold=#tmp1.length  from #tmp1 where #tmp3.tablename=#tmp1.tablename and#tmp3.colname=#tmp1.colnameupdate #tmp3 set xtypenew=#tmp2.xtype,lengthnew=#tmp2.length  from #tmp2 where #tmp3.tablename=#tmp2.tablename and#tmp3.colname=#tmp2.colnameselect * from #tmp3where xtypeold<>xtypenew or lengthold<>lengthnew drop table #tmp1drop table #tmp2drop table #tmp3