Christian Buettner-167247 (10/12/2010)
But what "stuns" me is the fact that SQL Server does not deal correctly with this object name.Looks like it is too complicated 😀
(...)
Notice the 2nd closing square bracket in the first line is missing.
Please check my previous reply for the long explanation.
The short explanation is that, within a [delimited identifier], you have to double the ] to get a single ] character.
(Just as you double a quote in a string to get a single quote character - i.e. SET @Name = 'O''Brien' )
(The same issue in the object browser. You cannot delete
You can always delete the table from the query window. Simply use the same SQL you used to create the table, but change "create" to "drop", and remove the column list.