sql query get server objects code example
Example: t-sql find object by name
-- SEARCHING FOR A SPECIFIC OBJECT CROSS DATABASE
SELECT
*
FROM
Sys.Objects
WHERE 1=1
AND name = '%HERE_THE_NAME_OF_OBJECT%'-- SEARCHING FOR A SPECIFIC OBJECT CROSS DATABASE
SELECT
*
FROM
Sys.Objects
WHERE 1=1
AND name = '%HERE_THE_NAME_OF_OBJECT%'