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

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

---

What is sql server profiler trace data file?

0 Answers  

---

Explain view in sql server?

0 Answers  

---

Explain different types of collation sensitivity?

0 Answers  

---

What is master database? : SQL Server Architecture

0 Answers  

---

---

How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,

---

What is dbcc?

0 Answers  

---

What is the Difference beween sql server 2005 and sql server 2008

3 Answers   CMC, Hitech,

---

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,

---

Write a sql query to get zero records from a table having n number of records?

0 Answers   TCS,

---

What is INTVAL( )and where we use Plz any body help me

1 Answers  

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

0 Answers   ABC, TCS,

---