Solved

Trigger Search By Keyword SQL Server 2000

Posted on 2007-03-21
3
186 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 250 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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

738 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