declare @isAvail bit

;WITH tbl as (
  SELECT object_id('SomeDB.dbo.SomeTbl_1') as [object_id]
  UNION ALL
  SELECT object_id('SomeDB.dbo.SomeTbl_2') as [object_id]
)
SELECT @isAvail = 
  CASE 
    WHEN exists(
      select 1
      from sys.dm_tran_locks
      where resource_database_id = DB_ID('SomeDB')
        and resource_associated_entity_id in ( SELECT [object_id] FROM tbl )
        and request_mode = 'Sch-M'
    ) THEN 0
  ELSE 1 END

select @isAvail