Thread: SQL Server 2005 Connection database

Hi all,I would assign to solve up various PCs to one sql 2005 database. I need to use SQL Server Compact Edition? If not how do I figure out the connections? If so where do I come across out how to do so?

I have upgraded a database server SQL Server 2005 Standard Edition. And a little application writes about ten records in the database via LAN. This application performce on various jobs from time to time. Access to SQL Server is defined with a attachment string in vb2005 and for a particular user. My question is simple what happens if two applications work together and try to get into SQL Server at once with the similar user?