when i am creating a trigger shows error

narasiman rao

9y747

The above one is doing in sql server 2008

tblemployeedetailsas follows

id int
Name Varchar(50)
Salary Varchar(50)
Gender Varchar(50)
Deptid int

Tblaudit as follows

id int
Auditdata varchar(50)

i am creating a trigger whenever record inserted in the tblemployeedetails, in tblaudit record will be inserted. for that i am creating a trigger as follows.

create triggger tbl_insert_foremployee
on tblemployeedetails
for insert
AS

BEGIN
declare @id int
select @id = id from inserted
insert into Tblauditdata
values ('New employee with id = ' + cast(@id as varchar(5)) +
'is added at ' + cast(Getdate() as nvarchar(20)))
END
GO

when i execute the above trigger shows error as follows

Unknown object type 'triggger' used in a CREATE, DROP, or ALTER statement.

please help me what is the mistake i made.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Furthermore, I would suggest that you change the structure of the tblAudit and keep data in proper table columns. How would you generate a report if you keep data in statements like 'New employee with id = 5 is added at March 19 2017'? If management asks for report employees added each month?

So make it more like:

tblAudit

Id - Identity column for the table, you can make it primary key.
EmployeeId - Id column from tblEmployeeDetails, you can make it a foreign key.
Operation - You can have I (for Insert), U (for update) and D (for delete).
OperationOn - DateTime
OperationBy - User Id performing an operation.

This way you can generate few reports. If you want more granularity, you can also have all columns from tblEmployeeDetails in this table and record their old value and new value.
Rajeev Punhani9y ago
Hi Narasiman,

First you have a typo error in keyword trigger. and then in trigger you have used wrong table name in insert query( Tblauditdata instead of Tblaudit).Also i think you should increase your Auditdata column size as you are specifying more characters in trigger insert statement.
create trigger [dbo].[tbl_insert_foremployee]
on [dbo].[tblemployeedetails]
for insert
AS

BEGIN
declare @id int
select @id = id from inserted
insert into Tblaudit (Auditdata)
values ('New employee with id = ' + cast(@id as varchar(5)) +
'is added at ' + cast(Getdate() as nvarchar(20)))
END
Ramesh Palanivel9y ago
Hi Narasiman,

In your code you have misspelled "triggger" text. Change the text "Trigger"

Kindly check that one,

May be the reason , you may have an issue.