• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

Trigger Search By Keyword SQL Server 2000

In SQL Server 2000, I want to do a search for a trigger based on keywords inside the trigger.  What is the command to do this?
0
Kaporch
Asked:
Kaporch
  • 3
1 Solution
 
rboyd56Commented:
How did you do this in SQL Server 2000?

0
 
rboyd56Commented:
Sorry I thought you said you did it in SQL Server 2000 and needed to do it in SQL Server 2005. Disregard my response.
0
 
rboyd56Commented:
See if this works for you:

select distinct sysobjects.name from sysobjects,syscomments where sysobjects.type = 'tr' and syscomments.text like '%keyword you want to search for%'

My syntax is not totally correct but the query should run.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now