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

What is role playing dimension with two examples? : sql server analysis services, ssas

980

How to enter binary string literals in ms sql server?

1126

How do I uninstall sql server 2014?

916

Where can you find the error log information? : sql server database administration

1003

Explain how dts is used to extract, transform and consolidate data?

977

What do you understand by coalesce in sql server?

1042

What are the advantages of partitioning?

1083

Define the one-to-one relationship while designing tables.

883

Is it safe to delete log files?

899

Is a primary key unique?

975

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

985

Explain insert into select statement?

929

What is built-in/administrator?

985

Other than truncate statement, which other command can by-pass the trigger on the tables?

1109

What is the purpose of data source?

1017