<div>
Hi,<br />
<br />
To echo reb73's comments for #2:<br />
It is easier to fix the network than maintain the sync of users databases to a central database. Assuming you are talking about a lan. And even for SQL replication, get the best WAN links you can.<br />
<br />
Cheers<br />
&nbsp; David
</div>


Hi,

To echo reb73's comments for #2:
It is easier to fix the network than maintain the sync of users databases to a central database. Assuming you are talking about a lan. And even for SQL replication, get the best WAN links you can.

Cheers
  David

<div>
<div class="content wysiwyg-content">
I obviously do not know much about SQL Server, as is evident by these 2 questions:<br />
<br />
1) If a company just has one SQL Server db on a server that is accessed by front end applications on 10 users' computers, would the company have to buy just 1 SQL Server license or 11 licenses?<br />
<br />
2) This question is completely unrelated. &nbsp;Can users have local copies of a SQL Server db to use when a network connection is unavailable? &nbsp;I assume the users would just synchronize as they would with Access? &nbsp;How come I never hear about local copies with SQL Server? &nbsp;There are several times I can think of when a user might want to use an application without access to a network connection.<br />
<br />
Thanks as always!!
</div>
</div>


I obviously do not know much about SQL Server, as is evident by these 2 questions:

1) If a company just has one SQL Server db on a server that is accessed by front end applications on 10 users' computers, would the company have to buy just 1 SQL Server license or 11 licenses?

2) This question is completely unrelated.  Can users have local copies of a SQL Server db to use when a network connection is unavailable?  I assume the users would just synchronize as they would with Access?  How come I never hear about local copies with SQL Server?  There are several times I can think of when a user might want to use an application without access to a network connection.

Thanks as always!!

SQL Server Licensing/Local Replica Questions

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.