Viewing 6 posts - 1 through 6 (of 6 total)
Thanks,
I ended up creating queue + notification service + event notification + SP with signature + queue activation.
SY.
December 27, 2011 at 2:27 pm
GSquared (12/27/2011)
ADD_ROLE_MEMBER and DROP_ROLE_MEMBER are capturable events at the server or database level, in DDL triggers.
I wish...
CREATE TRIGGER [AuditDDL_DDL_TRG]
ON DATABASE
FOR ADD_ROLE_MEMBER
AS
BEGIN
PRINT 'XXXXXXXXXXXXXXX'
END;
Msg 1082,...
December 27, 2011 at 12:47 pm
Sean Lange (11/7/2011)
OH this is a ddl trigger.
Well, database trigger is DDL trigger. Anyway, thanks for the link.
SY.
November 7, 2011 at 10:21 am
Lowell (11/7/2011)
what is the real name of the database trigger?
It is real name:
CREATE TRIGGER [database_trigger]
ON DATABASE
FOR ALTER_PROCEDURE
AS
BEGIN
print 'database_trigger'
END;
CREATE CERTIFICATE [cert_database_trigger]
ENCRYPTION BY PASSWORD = 'Dummy12345'
...
November 7, 2011 at 9:36 am
The error message is not a syntax issue. It clearly says that the object you are trying to alter by adding your digital signature either doesn't exist or you don't...
November 7, 2011 at 9:13 am
Sean Lange (11/7/2011)
That sounds like a permission issue. You can add a signature to a trigger. http://msdn.microsoft.com/en-us/library/ms181700.aspx
Thanks, but it is not a permission issue. I am dbowner. Trigger is created...
November 7, 2011 at 8:32 am
Viewing 6 posts - 1 through 6 (of 6 total)