Good afternoon... I wonder if anyone can help me with something which, as is often the way, I thought might be simpler.
I need to provide a list of columns and their associated datatypes that are in tables referenced by a large number of stored procs. Sp_Depends seems to get me most of the way to where I need to be, but alas does not return dependencies where the table being joined to is in a different database.
Does anyone have a brilliant idea that I can use and then look like a hero? Many thanks.