I have a relational database online. One of the tables that is tied to UserID is an Income table, so when people happen to make a payment, there is an automated process via Paypal that writes their payment into the income table.
My question is this: I can open the online database using SQLServerManagmentStudio. Is there any risk involved if I add a record to the Income table via SSMS while the database is active and online? Worst case (and highly unlikely) is that someone (with
a different UserID than the one I am adding income for) is making a payment causing the income table to be updated at the same time.
Does it matter if I have the database open in SSMS when a user adds data?
Can the system handle the possibility of two requests at the same time?
Thanks for any insight on this.
Go to the complete details ...