Does example #7 in the article at the following link do it for you?  You can add criteria to only consider stored procedures.

https://www.mssqltips.com/sqlservertip/2999/different-ways-to-find-sql-server-object-dependencies/

Tru dat!

That other post can be found at the following link...

https://www.sqlservercentral.com/forums/topic/tracing-a-performance-issue

Removed accidental dupe post.

There's been some good things since 17 hit the streets.  They did, however, break copy'n'paste.  I have a special color (Red) that I use for ALL constants and a special...

It's also going to miss any and all "whole dates" (a.k.a. dates with a midnight time) for the 3 years involved.  The > should have been >= in all 3...

Ya just gotta...

I believe the more common, and better, naming for tables is plural.  I can't think of a major relational dbms that uses singular system table names.

For example: sys.objects (SQL...

Thank you all for getting back to me. I appreciate the advice. Because of your advice, I won't make a big deal out of removing the ID. Oddly, I...

That's the same reaction I had when the size charts gave me a hint about what was...

Bumping my own post because of the 2nd page issue on this forum.

Sorry and done.

It's free.  Like it says in the presentation, send me an email to the email address I provided and I'll send you the zip file that I give folks when...

Heh... "It's Shake'n'Bake and I helped"! 😀

Welcome but, if you're going to say something like that, you should explain why...