When I was comparing data between 2 database. I was getting following error
" The following error message was returned from the SQL Server:
 The size (6000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000).
The following SQL command caused the error:
SELECT [SpecElementID], [SpecElementIDLbDependent], [StructureId], convert(nvarchar(6000),[Formula]) COLLATE Latin1_General_BIN , [ParentStructureId]
FROM [dbo].[tbCoElementSpecRefLinkBase] WITH (NOLOCK) ORDER BY [SpecElementID], [SpecElementIDLbDependent], [StructureId] "
and same error occure while comparie text datatype. Anybody could give me a solution