what are the main differences between ms access and sqlserver
- 1 Answers
- 4318 Views
- C DAC, CDAC, I also Faced
- E-Mail Answers
Answer Posted / appu
Access is installed as part of the Microsoft Office suite.
SQL Server can be quite expensive.
Access is more suited for desktop use with a small number of users accessing it simultaneously. One reason you might choose to use Access over SQL Server is for compatibility/sharing.
SQL Server was designed to have many hundreds, or even thousands of users accessing it at any point in time.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is the command used to recompile the stored procedure at run time?
What is the cpu pressure?
Mention the different types of replication in sql server.
can any body tell me how to know the password of current user in sql server
What types of Joins are possible with Sql Server?
What is shrink log file?
What is the default sql server instance name?
What are ddl (data definition language) statements for tables in ms sql server?
Explain what is lock escalation?
What is change tracking in sql server?
What is the beast way to write CTE in SQL Server ?
Do you know the cursor types?
What are the two authentication modes in sql server?
What is a primary index?
How to list all user defined functions in the current database?
