In SQL Server 2005 you can get a list of all your Tables with a particular name using the system table sys.table:
SELECT *
FROM sys.tables
WHERE name LIKE '%YOUR_TABLE_NAME%'
but if you need to do the same task in a SQL Server 2000, you should use
use YOURDB
select *
from INFORMATION_SCHEMA.TABLES
where TABLE_NAME LIKE '%YOUR_TABLE_NAME%'
because sys.table is not supported into SQL 2000.