I tried this out but it wont send out a trigger
CREATE TRIGGER tr_deleted_Cust omer1
ON Customer
AFTER DELETE
AS
--Advise whose been deleted
IF EXISTS (SELECT * FROM deleted WHERE [Customer Number] = 'A-Z')
BEGIN
DECLARE @Count nvarchar
PRINT CAST(@Count as varchar(3))+' row(s) were deleted '
END
go
der0
Last Activity: Mar 28 '08, 05:24 AM
Joined: Mar 26 '08
Location:
-
How would I do it though?Leave a comment:
-
I guess it needs to be more of a trigger than an alert. I created a custom db with a table that has client numbers on it. To test it I want to delete a clients information and have a trigger notify me that the table information has been altered. I did a little more reading the other night and I saw something on the ADD,INSERT, DELETE trigger. Any suggestions?...Leave a comment:
-
Creating an alert for a deleted row
Hello,
I am just learning how to use SQL Server 2000 and I want to create an alert in which I delete a row from a table and I receive an alert notifying me that the row has been deleted. Can anyone help?
No activity results to display
Leave a comment: