Member Avatar for cheapterp

I am using the SQL 2005 Express edition for SQL server. The database resides on another server and I connect to it from my machine through the object explorer. I have created a trigger to run certain queries and updates, but can't seem to find the trigger listed under

MyDB->Programmability->Database Triggers

I can get a list of all the objects using the SELECT * FROM sysobjects , but I am sure there has to be something in the GUI where I can look at it (and perhaps it's properties, too)

I know the trigger exists because the DB is updated exactly the way I want it to!

I have no such problems with my Stored Procedures, but do not know why my Triggers are invisible! Is the trigger hiding because it resides on a remote server?

Thanks!

  • 2 Contributors
  • 1 Reply
  • 123 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by sknake
Member Avatar for sknake

Database Triggers:

DDL Triggers are a special kind of trigger that fire in response to Data Definition Language (DDL) statements. They can be used to perform administrative tasks in the database such as auditing and regulating database operations.

You're looking for a table specific trigger and not a database trigger. Expand your table list and then expand an individual table. You will see a "Triggers" item below the table.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.