?
Solved

Trigger Search By Keyword SQL Server 2000

Posted on 2007-03-21
3
Medium Priority
?
188 Views
Last Modified: 2010-03-19
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
Comment
Question by:Kaporch
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
3 Comments
 
LVL 16

Expert Comment

by:rboyd56
ID: 18766417
How did you do this in SQL Server 2000?

0
 
LVL 16

Expert Comment

by:rboyd56
ID: 18766424
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
 
LVL 16

Accepted Solution

by:
rboyd56 earned 1000 total points
ID: 18766467
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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question