I have a SQL Server 2005 SP3 box that one of my developers created a temp table on that we cannot seem to remove because it somehow got brackets in the name of the table?
SELECT Name, object_id FROM sys.objects WHERE Name LIKE '%#example%'
Results:
Name object_id
[#example] 123828384
Anyone know how we can get rid of this? Thanks!