Jobin Joseph Jobin Joseph - 1 year ago 73
SQL Question

Is it possible to insert records into a table from more than one users at same time?

Is it possible to insert into same table from more than one users at same time? I have scenario where around 10 users will be inserting to the same table, the number of insertions can be 30/40 per minute from each user.

Will this make a deadlock in the database?

Answer Source

Your app can list any available sql servers on the network if there is only one then connect to it. If more than one put a dialog up to the users to confirm.

You can use:

sqlcmd -L 

That will return any visible sql servers