SET QUOTED_IDENTIFIER ON
GO
sp_msforeachdb "use ? ; SELECT name AS Table_Name,xtype AS type,’?’ AS DB_Name FROM sysobjects WHERE name LIKE ‘object_name%’"
searching object across the databases.
- Leave a comment
GCFE
GIAC Certified Forensic Examiner
GCIH
GIAC Certified Incident Handler
AWS SAA
Stackoverflow
Stackoverflow
LinkedIn
RSS Feed
Ashish Gupta 