[RESOLVED] Cannot access global temporary table in SQL 2005

[dee-u]

The following works in sql 2000 but not in 2005, it complains "Invalid object name '##DummyTable'".

SET @command = 'bcp "..##DummyTable" out "' + @ZipFile + '" -c -U "' + @username + '" -P "' + @password + '"'

Why is this?