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

Explain some DBCC commands?

6 Answers  

---

Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,

---

How to set database to be read_only in ms sql server?

0 Answers  

---

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,

---

what is the difference between table and view

1 Answers  

---

What is store procedure? How do they work?

0 Answers  

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

0 Answers  

---

How to execute a sql statement using odbc_exec()?

0 Answers  

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

---

Difference between LEN() and DATALENGTH() in sql server ?

0 Answers   HCL,

---

What is 1nf 2nf and 3nf?

0 Answers  

---