nvarchar(max) truncated dyanmic sql

Erland you're right the query is not truncated the XML showed complete query

Thanks

The setting that controls how many characters are displayed in SSMS output is below

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://ift.tt/19nLNVq http://ift.tt/1iEAj0c