SqlServerKudos - Find Recently Executed Stored Procedures

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

1
kudos

Kudos

Find Recently Executed Stored Procedures

published 358 days, 5 hours, 48 minutes ago posted by

sa 362 days, 3 hours, 38 minutes ago

Find Recently Executed Stored Procedures

This past weekend, we had an issue where replication fell far behind on one of our databases. The replicated database is used for all sorts of reporting, so the immediate need was to identify processes that may have been affected by the incomplete data. Now, there’s hundreds of stored procedures that reference the affected database; the trick is finding out which ones are relevant. To do this, I used the sy...

category: Query | clicked: 3 | | source: sqlfool.com | show counter code

tags: SQL Tips, Syndication, T-SQL Scripts

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

SqlServerKudos