[RESOLVED] Cannot access global temporary table in SQL 2005

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

Code:

---

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

---

Why is this?

Anyone who has a clue?

I just have to specify the server parameter and it worked.

Code:

---

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

---