I know it may not be good design standards, but SQL7 can handle
database names that have embedded spaces just fine, you just need to
enclose the database name in square brackets. But can TEXTCOPY handle
spaces in the database name?
I first tried something like:
TEXTCOPY /S server /U sa /P password /D mydatabase /t [table name]
/C columnname /W "where id = 1" /F file.txt /O
Ultimate goal here is to extract the text contents from the column
columnname and write it to a file called file.txt. But the command
puked on the square brackets. I tried the same command structured like
this:
TEXTCOPY /S server /U sa /P password /D mydatabase /t "table name"
/C columnname /W "where id = 1" /F file.txt /O
But it didn't like that either. Any suggestions? I ended up renaming
the table to a table name without any spaces, like table_name, but I
would rather have not solved the situation in that manner.