Wednesday, December 3, 2014

nvarchar(max) error

Hi,


I'm not aware of the SSRS architecture, if by any chance SSRS executes queries using OPENQUERY then maximum length of the string is 8 KB, this could be the reason in your case.


Refer following article.


OPENQUERY




Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker

Praveen Dsa | MCITP - Database Administrator 2008 | My Blog | My Page


No comments:

Post a Comment