InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 14:20:52 GMT20http://www.sqlservercentral.com/Forums/Topic1408402-392-1.aspxMany thanks, greatly appreciated.Mon, 21 Jan 2013 04:03:09 GMTMr. Cursorhttp://www.sqlservercentral.com/Forums/Topic1408402-392-1.aspxthis can get you started: it shows every dependency that is using a cross database reference:[code]select OBJECT_NAME(referencing_id) As ViewName,OBJECT_NAME(referenced_id) As ReferencedObject,*from sys.sql_expression_dependencies where referenced_database_name is not null[/code]getting the column names from the remote server is going to require some dynamic sql to extract i think, since you cannot use a value in a table to use as part of joined object.Thu, 17 Jan 2013 08:21:41 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1408402-392-1.aspxGood 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.JThu, 17 Jan 2013 06:52:55 GMTMr. Cursor