recompiling triggers 
Author Message
 recompiling triggers
Hi All,

I would like to find out if there is a system stored procedure that can be
called to recompile a specific trigger.  What I am trying to do is write a
stored procedure which will find all the triggers in a particular SQL Server
6.5 database, find the dependent triggers and recompile them.

Bilal M. Abbasi



Sat, 07 Jul 2001 03:00:00 GMT
 recompiling triggers

What I've done in the past is build a cursor that loops through all the user
tables in a database and execs sp_recompile against each.  I suppose you
could figure out how to modify system tables to cause this to happen somehow
(I've never thought about how), but my script runs fast enough that that
kind of effort didn't seem necessary.

--
Bob Pfeiff
MCSD, MCT, SQL Server MVP



Sat, 07 Jul 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. to recompile or not recompile postgres

2. WITH RECOMPILE does not recompile???

3. Trigger getting recompiled very frequently

4. Procedure cache - trigger recompile

5. Trigger Recompiles

6. DB triggers and recompiles

7. Recompile after Trigger change

8. Triggers, Triggers and more Triggers

9. Missing Profiler Events - SP:Recompile For Example?

10. Recompiling Views

11. how to recompile all stored procedures

12. updating statistics and recompiling stored procedures


 
Powered by phpBB® Forum Software