jitendra.padhiyar (9/11/2012)
My question is what will happen when the length of the row is more than maximum capacity of sql server?
If the row is comprised of fixed-length data types, you'll get an error creating the table. If there are variable-length,they overflow onto LOB pages (much as Varchar(max) and the other max data types are handled).
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability