Access can store only 2 GB of data where as in SQLSERVER 2005 one column ca

why SQL server is more used to store database rather than
Access

Question Posted / anilreddy

Answer Posted / anilreddy

Access can store only 2 GB of data where as in SQLSERVER 2005 one column can store more than 2 GB of data

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Do you know how to send email from database?

1005

What is sql sandbox in sql server?

1224

What is the need for indexing?

951

How does using a separate hard drive for several database objects improves performance right away?

932

What is scheduled job and how to create it?

993

What is a db view?

900

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2071

What is cursors?

1186

can SSRS reports Cache results?

147

Can you explain what is the use of custom fields in report?

1062

Tell me what is sql profiler?

1029

What do you understand by coalesce in sql server?

1069

How many databases Microsoft SQL server provides?

1088

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

950

Define right outer join?

981