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

How do I find the transaction log size in sql server?

0 Answers  

---

Explain the new features of SQL server 2000?

1 Answers  

---

How to include date and time values in sql statements?

0 Answers  

---

What is a mixed extent?

0 Answers  

---

What is database mirroring?

0 Answers  

---

---

What are tables in sql server?

0 Answers  

---

What is sql collation?

0 Answers  

---

How to bind a view to the schema of the underlying tables?

0 Answers  

---

What are the purposes of floor and sign functions?

0 Answers  

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  

---

Can you explain what are commit and rollback in sql?

0 Answers  

---