Jobin Joseph Jobin Joseph - 3 months ago 13
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

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

Comments