[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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