Home Forums SQL Server 2012 SQL Server 2012 - T-SQL List the Objects referenced outside of the db RE: List the Objects referenced outside of the db
vignesh.ms
Hall of Fame
Points: 3456
More actions
February 23, 2015 at 3:51 am
#1779213
Eirikur Eiriksson (2/23/2015)Quick suggestion, use the sys.sql_expression_dependencies system view😎SELECT SD.*FROM sys.sql_expression_dependencies SDWHERE SD.referenced_database_name IS NOT NULL;
Eirikur Eiriksson (2/23/2015)
😎
SELECT
SD.*
FROM sys.sql_expression_dependencies SD
WHERE SD.referenced_database_name IS NOT NULL
;
Great.. works fine