Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

why SQL server is more used to store database rather than
Access

Question Posted / guest

Answers were Sorted based on User's Feedback



why SQL server is more used to store database rather than Access..

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.

Is This Answer Correct ?    2 Yes 0 No

why SQL server is more used to store database rather than Access..

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

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What r sql reporting services and analysis services? how can we use it.

2 Answers   Microsoft,

Can we linked SharePoint to a SQL database?

0 Answers   Sans Pareil IT Services,

How can you check the version of sql server?

0 Answers  

how you can list all the tables in a database?

0 Answers  

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 Answers  

What is a collation?

0 Answers  

What are the different types of replication are there in sql server 2000?

0 Answers  

Explain the different index configurations a table can have?

0 Answers  

How you can add messages to the nt event log from within a stored procedure?

0 Answers  

List down some advantages of sql stored procedure?

0 Answers  

How many types of keys are there?

0 Answers  

How to get all stored procedures in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories