ADS 17.0.0 Dev -3
1.Connect to MS SQL server 2014.
2.Create any trigger.
CREATE TABLE [db_accessadmin].[project_employee] (
[emp_id] numeric(15,5) NOT NULL,
[Emp_Name] varchar(25) NOT NULL,
[Emp_Password] varchar(25) NOT NULL,
[Emp_username] varchar(25) NOT NULL,
[employee_type_id] varchar(25) NOT NULL,
CONSTRAINT [pk_eid] PRIMARY KEY CLUSTERED([emp_id])
)
GO
CREATE TRIGGER [db_accessadmin].[trgAfterDelete] ON [db_accessadmin].[project_employee]
AFTER DELETE
AS
insert into project_employee_audit(Emp_name,Emp_username,Emp_password,action,update_date)
select Emp_Name,Emp_username,Emp_Password,'This employee record has been deleted ',getdate()
from deleted
GO
3.Table and Trigger created successfully.
4.Go to Triggers node.
5.Right click on created trigger,select option "Drop Trigger".
6.Drop Trigger pop up displayed for confirmation.
7.Observe displayed message on pop up.
"Are you sure you want to Drop Server Trigger? db_acessadmin_trgAfterDelete?
8.Here why we have inserted "?" symbol before trigger name?(see attached screenshot).
message will now read: Are you sure you want to DROP the server trigger '<schema>.<trigger>'?