help running a dos script with a space in it

Question

i am running this:

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql -E -S Sql server-hl7\timeclockplus timeclockplus.sql -oresults.txt

and it doesnt like that there are spaces in the directory. how do i fix this problem?

Answer 1

Does this work?

"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql" -E -S "Sql server-hl7\timeclockplus timeclockplus.sql" -oresults.txt

Answer 2

Try:

"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql" -E -S "Sql server-hl7\timeclockplus timeclockplus.sql" -oresults.txt

You may have to include the ".exe" as well, but generally in DOS this is how spaces are handled.