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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 sourcing a stored procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-31 : 09:33:48
adric writes "The procedure is a generic triggered procedure which can be
triggered by an update to any of a group of tables. The rules
apply to all of the tables when updated, but the procedure needs
to know which table triggered it. It is impratical to write one
procedure for each of the 175 tables that will use this
procedure and it is equally impratical to write a triggered procedure
to pass the name of the table. How can the procedure determine
which table triggered it?"
   

- Advertisement -