A Table *named* "dbo.tSales"

Here's a good one:

I have a table *named* "dbo.tSales", in addition to being owned by dbo. The fully qualified name would look like "databasename.dbo.dbo.tSales".

In other words, the name starts with "dbo." and shows up in the output when you do:

select name from sysobjects where name like '%Sales' and type = 'u'
name
------------------------------
dbo.tSales
tSales


"tSales" is a real table, also owned by dbo. I don't know how the bogus table got there. The only reason that I've noticed this is because Backup Exec tries to backup this table by explicitly naming it in a DUMP TABLE statement and the statement fails on syntax because the fully qualified name has too many periods in it.

I can't select from dbo.tSales, rename it or drop it using TSQL or SEM. All methods fail because they are expecting that the tablename cannot contain any periods, since the period is a delimiter.

My question: How can I get rid of this table?


-darin!