Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQL_Stinger
Starting Member
40 Posts |
 Posted - 2001-04-20 : 12:56:37
|
| We are running SQL2K on Win2K. We are developing an Internet application using ASP, COM and SQL. Here are a couple of questions we keep batting around. Any suggestions, gurus?1 - If COM runs a stored procedure which, in turn, fires a trigger and then COM rolls back the stored procedure, will the trigger roll back as well? My COM developer says that the trigger will not roll back because it is outside the scope of COM. I say that SQL will roll back the trigger if the stored procedure is rolled back.2 - If two users fire run the same stored procedure at the same time, will SQL queue the second call until the first is complete? A DBA friend says that the second call will be queued until the first is complete and SQL can access the code for the procedure. I think the second call may have to wait due to locks on the data being accessed by the procedure, but the second call shouldn't have to wait on the code of the procedure.Thanks in advance. You guys are the best. Keep up the good work.--------------------SQL Stinger |
|
|
|
|
|
Stored Procedures, Triggers and COM (Oh my!)