Try and see [<img src='/community/emoticons/emotion-5.gif' alt='' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
quote:Originally posted by rao Thanks Madhu... Getting an error. Looking for how to overcome. FYI, I am Madhivanan No alternative. You cant have row exceeding that limit Madhivanan Failing to plan is Planning to fail
Check "Row-Overflow Data Exceeding 8 KB" topic in BOL.. SQL Server 2005 Books Online Row-Overflow Data Exceeding 8 KB http://msdn2.microsoft.com/en-us/library/ms186981.aspx http://blogs.msdn.com/msdnts/archive/2006/12/01/row-size-limitation-in-sql-2000-and-2005.aspx MohammedU. Moderator SQL-Server-Performance.com