[RESOLVED] Cannot access global temporary table in SQL 2005

**dee-u** · Sep 15th, 2009, 04:19 AM

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?

**dee-u** · Sep 17th, 2009, 12:37 AM

Anyone who has a clue?

**dee-u** · Sep 18th, 2009, 08:44 PM

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 + '"'

Thread: [RESOLVED] Cannot access global temporary table in SQL 2005