OK thanks

I thought Elvis was dead.

This is why I mentioned Jeff.

Glad to see Jeff is here, I know he'll have some interesting insight onnthis question.

CTE or View, which to use and when as well as why?

I personally use both a...

UPDATE: After some addiotnal checking I found that there are 2 built in DMM's that can be used to shows teh same info that you see in SSMS's View Dependencies;...

All - I ended up figuring out a way to do this; SSMS's View Dependencies. If you select the SP you want to get the hierarchy for and select Objects...

OMG. This vendor has soooo many cursors. Pretty much all updates to transactions (charges, receipts, check, invoices) are done using a cursor.  In more recent years I heard they finally...

I can't say the same applies to your situation but on my end when the vendor does reports they charge a lot (I used to make those reports mostly in...

Out of curiosity what type of reports were they making? Was it using one of teh 3rd party popular custom reporting apps like Crystal Reports or SSRS or was it...

My absolute pleasure and like you I have been thru the painful move to the vendor's cloud and since we've stopped having the app on-prem things have been a lot...

Jeff - I just took a look at the article and gave it a try and none of the examples work for an SP. I see that they list SP's...

Thanks soooo much Jeff!

This did not work for me. I have a SP called LF5_JOb that contains the line EXECUTE LF5_Job2 and your code did not show this

fyi.. THSI ONLY SHOWS THE FIRST sp THAT THE NAMED sp IS CALLING. fOR EXAMPLE IF i HAVE THE FOLLOWING sp

LF5_Job

LF5_Job2

LF5_Job3

LF5_CalcFess

Where LF5_Job calls LF5_Job2 and Lf5_Job2 Calls Lf5_Job3 and LF5_CalcFees

When...

After getting a lot of heat from angry customers RG did make a formal posting about the issue acknowledging the problems with SQL History and said they're working on it. ...