trigger not showing 2

[sparkbyte]

Not sure what I have done.

In SSMS after creating a trigger.

Use MailroomTracking

Go

Alter Trigger trg_EmployeeProperName
    On tblEmployee

For Insert, Update

As
Begin

  Set Nocount On

  Update  dbo.tblEmployee
  Set     tblEmployee.EmployeeFN = dbo.fn_ProperCase(I.EmployeeFN),
          tblEmployee.EmployeeMI = dbo.fn_ProperCase(I.EmployeeMI),
          tblEmployee.EmployeeLN = dbo.fn_ProperCase(I.EmployeeLN)
  From    dbo.tblEmployee
          Inner Join Inserted As I
            On dbo.tblEmployee.EmployeePK = I.EmployeePK
End

The trigger does not show up in SSMS.

I thaught it should show up under
Databases
|
--> DDName
|
-->Programmability
|
--> Database Triggers

The trigger is running but I can't seem to find where it was saved to.





Thanks

John Fuhrman

 

[ca8msm]

IN SSMS it is listed under the table e.g.

Server
-Databases
--DBName
---Tables
---TableName
---Triggers


Mark,

Darlington Web Design[tab]|[tab]Experts, Information, Ideas & Knowledge[tab]|[tab]ASP.NET Tips & Tricks

 

[SgtJarrow]

That trigger seems to be applied to a table. Look under the table you you will see Triggers. Your trigger should be there, under tblEmployee

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer