OLE DB provider 'SQLNCLI' for linked server '' returned data that does not match expected data length for column '[server].[database].[dbo].[view]'. The (maximum) expected data length is <number>, while the returned data length is <number>.

After creating a linked server in ms sql express. and running the view I got the following error. to solve the problem run sp_refreshview command from the server that is hosting the view.

 

sp_refreshview [ @viewname = ] 'viewname' 

http://msdn.microsoft.com/en-us/library/ms187821.aspx