lukus_g (10/12/2010)

---

so, does the transaction actually run and get rolled back?

VarArray[](i int)
GO
begin tran
    insert into VarArray(i) select 1
rollback
GO
while(1=1)

--Original name from the create table statement:

VarArray[]](i int)
--GO
begin tran
insert into Vararray(i) SELECT 1
rollback
--GO
while 1 = 1

SELECT NAME FROM sys.objects WHERE name LIKE 'Var%'

VarArray[](i int)
--GO
begin tran
insert into Vararray(i) SELECT 1
rollback
--GO
while 1 = 1

This example is the query used to send a formatted html by xp_sendmail:

-- to test send output to text or file c:\temp\1.htm
SET NOCOUNT ON
select '' AS []
SELECT 
 ' ' AS [ ]
...
 

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 :D
(...)
Notice the 2nd closing square bracket in the first line is missing.

(The same issue in the object browser. You cannot delete