declare @view_name sysname;
set @view_name='vwTest';
select name [in local, not remote] from syscolumns
where id = (select id from sysobjects where name = @view_name)
and name not in (
select name from REMOTESERVER.REMOTE_DB.dbo.syscolumns
where id = (select id from sysobjects where name = @view_name)
)

select name [in remote, not local] from REMOTESERVER.REMOTE_DB.dbo.syscolumns
where id = (select id from sysobjects where name = @view_name)
and name not in (select name from syscolumns 
where id = (select id from sysobjects where name = @view_name)
)

--This script will compare the columns of all tables and views
--in the two databases. Returns all columns found in only one database
--or columns with a different datatype or datatype max length
select table_name, column_name, data_type, 
character_maximum_length, min(table_catalog) AS DB
from
(
  select table_catalog, table_name, column_name, data_type, character_maximum_length 
  from db1.information_schema.columns

union all

  select table_catalog, table_name, column_name, data_type, character_maximum_length 
  from db2.information_schema.columns
)b

group by table_name, column_name, data_type, character_maximum_length having count(*) = 1

quote:

---

Originally posted by mohdowais

Straight out of my toolbox:

---