if you're stuck in a pre 2005 world you would do:

select * from sysobjects where type ='u'

and name like '%your_table_name%'