Hi
I start some stored procedures using tStoredProcedure.
Until now, I've assumed that if I start the same stored procedure from different programs, they would not run simultanoeusly as long as I packed them in StartTransaction/Commit/Rollback.
Now I get some errors that seems to indicate that is not the case
Is that correct?
If that is the case, and I now have to make sure I don't run them at the same time, how do I run stored procedures in the same database from different programs?
Best regards
Poul
Does tStoredProcedure run after execute?
-
AndreyZ
Hello,
SQL Server runs transactions simultaneuosly by default. You can avoid it by redesigning your stored procedure to run it concurrently, or by using application locks. You can find more informatilon about these approaches here:
http://msdn.microsoft.com/en-us/library/ms189823.aspx
http://www.sqlservercentral.com/Forums/ ... 386-1.aspx
SQL Server runs transactions simultaneuosly by default. You can avoid it by redesigning your stored procedure to run it concurrently, or by using application locks. You can find more informatilon about these approaches here:
http://msdn.microsoft.com/en-us/library/ms189823.aspx
http://www.sqlservercentral.com/Forums/ ... 386-1.aspx