Getting ghostly errors in SQL Server 2008

You probably have another object in the database with that name. Run

SELECT *
 from sys.objects
 where name = 'YourName'

and see what pops up. ("Objects" includes tables, views, procedure, functions, defaults, and a whole lot of other obscure stuff.)