Another Challenge/New things to learn i have scenario like
I want to list the stored procedures,view,Function ,SQL jobs if used the IP address inside the stored procedure/views/Function/ SQL jobs.
Is it possible to get?
I have one sample below for understanding the concept
The above Function used the ip address '192.168.1.78'. so I want to list out if Any of IP Address SP/Views/function/sql jobs used means I want to list out
If I understand the question, and I'm not entirely sure I do, you need to look at setting up a trace events job within SQL SErver. You can make it so that it captures the remote procedure call and the sql batch to see what parameters and values are passed to a query. In order to see individual statements you'd have to do a statement level trace, but those are very expensive both in terms of impact on the server and the amount of data you'll be collecting. Exercise extreme caution if you go that route. Gail Shaw's article on identifying long running queries shows how to set up the trace events.
answered Jan 29, 2013 at 10:20 AM
Grant Fritchey ♦♦