Answer / murtaza

1.sql server supports Relational database Management Systems
whereas access does not support all the features of RDBMS.
2.sql server 2005 supports partitioning,bcp utility,Data
transformation services(DTS),SSIS which r not supported by
access
3.sql server 2005 supports crystal reports for reporting
services and can be use as an BI tool for OLAP Queries
access does not support crystal reports and does not support
BI tool.
4.sql server supports more large and mid size data processing
and access does not support volumnous data.

Answer / anilreddy

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

What are the filtered indexes?

0 Answers  

---

What is the command used to check locks in microsoft sql server?

0 Answers  

---

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

---

how to get the rowid/rownumbes of a table in sqlserver

7 Answers   IBM,

---

Define magic tables in sql server?

0 Answers  

---

---

What are commonly used mssql functions in php?

0 Answers  

---

What is difference between delete and truncate commands?

0 Answers  

---

What are the difference between clustered and a non-clustered index?

0 Answers  

---

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

---

Explain the etl (extraction, transformation, and loading)?

0 Answers  

---

What are page splits? : SQL Server Architecture

0 Answers  

---

What is the difference between constraints and triggers?

9 Answers   Wipro,

---