what are the main differences between ms access and sqlserver
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
Can you explain powershell included in sql server 2008?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What will be query used to get the list of triggers in a database?
When we should use @@error?
What are different types of views?
how can you check the level of fragmentation on a table? : Sql server administration
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Give an example of SQL injection attack ?
How do you know if sql server is running on your local system?
What are views in ms sql server?
How to create a trigger for insert only?
How you trouble shoot when any job fails
What is the definition for sql server 2000?
How to create a scrollable cursor with the scroll option?