Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: robincbailey
- Order by date
-
trigger stopped firing SQL 2000
The trigger is not disabled and is still not firing. This trigger was working for about 8 weeks but has just stopped. I have had this before when one of the other databases had a transaction log that grew to 20GB, I have since deleted the log file and set a limit on against it of 2GB. I am...- robincbailey
- Post #9
- Forum: Microsoft SQL Server: Programming
-
trigger stopped firing SQL 2000
Thanks Guys, Firstly how do I tell if a trigger is disabled? The idea behind this trigger is that single rows get updated and this will copy any row across where all of the fields have been filled- robincbailey
- Post #4
- Forum: Microsoft SQL Server: Programming
-
trigger stopped firing SQL 2000
A trigger that was working, has for some reason stopped firing. I know that the trigger has not changed, but what else could be causing this? CREATE TRIGGER copy_across ON dbo.rms_inventory_temp FOR UPDATE, INSERT AS DECLARE @inventid VARCHAR(16), @description VARCHAR(30), @location...- robincbailey
- Thread
- Replies: 10
- Forum: Microsoft SQL Server: Programming
-
trigger stopped firing
A trigger that was working has for some reason stopped firing. I know that the trigger has not changed, but what else could be causing this?- robincbailey
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
