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 to drop an existing user defined function in ms sql server?

0 Answers  

---

Do you know the policy based administration feature of sql server 2008?

0 Answers  

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

---

What is the purpose of linked server configuration in sql server?

0 Answers  

---

What are the different SQL Server Versions you have worked on?

0 Answers  

---

How to change the password of a login name in ms sql server?

0 Answers  

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

---

What are the properties of the transactions?

0 Answers  

---

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

---

What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  

---

Do you know what is blocking?

0 Answers  

---