The following works in sql 2000 but not in 2005, it complains "Invalid object name '##DummyTable'".
Why is this?Code:SET @command = 'bcp "..##DummyTable" out "' + @ZipFile + '" -c -U "' + @username + '" -P "' + @password + '"'
Printable View
The following works in sql 2000 but not in 2005, it complains "Invalid object name '##DummyTable'".
Why is this?Code:SET @command = 'bcp "..##DummyTable" out "' + @ZipFile + '" -c -U "' + @username + '" -P "' + @password + '"'
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 + '"'