Solved

Tracing an Alert to Where It's Used

Posted on 2009-07-16
5
154 Views
Last Modified: 2012-05-07
[Sql Server 2005 SP2]

In my "Alerts" folder, I have an alert that I created once upon a time called "UserSettable1".

I cannot for the life of me remember why I created this, but I do believe that it was and is useful.  I think it's being used somewhere, by something.

How do I figure out what's using this alert, and how it's being used?

Thanks
0
Comment
Question by:bamapie
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:Philip Pinnell
ID: 24870456
I can only suggest scripting the whole database and doing a text search for the alert you are looking for.


0
 

Author Comment

by:bamapie
ID: 25223913
Andy, how would I do what you describe?
0
 
LVL 13

Accepted Solution

by:
Philip Pinnell earned 500 total points
ID: 25229358
right click the database
then "tasks"
then "generate scripts"

This starts up a wizard where you select all the objects to script and where to put the output (file, new quey window,...)
0
 

Author Closing Comment

by:bamapie
ID: 31604274
Sorry, Andy, for not grading this sooner.
0
 
LVL 13

Expert Comment

by:Philip Pinnell
ID: 25339909
Thanks

No problem
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now