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?
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:
That will return any visible sql servers