what is the maximum size of a row in sql server 2000 and 2005

Answer Posted / naresh

8kb and if data(datatypes-varchar,varbinary) exceeds the
8kb row then proceeds to next page pointing with Pointers

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is join and name different type of joins?

774


What is the sql profiler?

689


Do you know what is a linked server in sql server?

714


Where sql server user names and passwords are stored in sql server? : sql server database administration

795


What to perform pattern match with the like operator?

657






What is 5nf in normalization form?

729


What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

789


Explain about merge replications?

768


How to create new tables with "select ... Into" statements in ms sql server?

681


How to connect php with different port numbers?

723


How is sql used in sql server?

672


What are data driven subscriptions?

95


How to create “dependant” parameter “make, model, year”

105


What are the properties of the relational tables?

629


What Are the Main Features of SQL Azure?

109