SQL Server – Find an object by name – sys.all_objects Posted by Ray Fox 0 Database Level use [<dbname>] select * from sys.all_objects where name = 'BATCH_JOB_SEQ';