Subject | Disable Stored Proc? |
---|---|
Author | Ed Dressel |
Post date | 2007-11-21T01:27:28Z |
Can a stored proc be disable?
What I am needing to do is stop a LastUpdated date-time field from
being updated when I make a change to a data table.
For example, when I add a field, then set the value of the field, the
before update trigger will call a stored procedure with a ID of the
master table to set the LastUpdated field with the current date/time.
I want to disable the stored procedure from changing so that my
changes to the table don't set the LastUpdate field for all of the
records.
Thanks
What I am needing to do is stop a LastUpdated date-time field from
being updated when I make a change to a data table.
For example, when I add a field, then set the value of the field, the
before update trigger will call a stored procedure with a ID of the
master table to set the LastUpdated field with the current date/time.
I want to disable the stored procedure from changing so that my
changes to the table don't set the LastUpdate field for all of the
records.
Thanks