Does tStoredProcedure run after execute?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 17
Joined: Thu 25 Jan 2007 02:35

Does tStoredProcedure run after execute?

Post by DerPaul » Fri 27 May 2011 14:53


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



Post by AndreyZ » Mon 30 May 2011 08:34


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: ... 386-1.aspx

Post Reply