8kb and if data(datatypes-varchar,varbinary) exceeds the 8kb row then pr

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

Question Posted / naresh

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

Please Help Members By Posting Answers For Below Questions

Can we use where and having clause together?

981

Define magic tables in sql server?

993

What happens if null values are involved in datetime operations?

907

Mention the differences between sql server and mysql.

950

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

990

What is difference between views and tables?

914

How will you monitor replication latency in transactional replication? : sql server replication

1089

How to throw custom exception in Stored Procedure?

994

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1007

What is the difference between system objects and user objects?

1103

What is relationship? What number of sorts of relationship are there?

1065

What the different components in replication and what is their use?

915

Name some of the open source software that you can use in alternative to SSR?

151

What is rank function?

978

Can you please explain the difference between primary keys and foreign keys?

1059