Posted by Desmodromic on 11/22/07 06:19

The command below runs fine from within Management Studio

exec sp_MSforeachtable @command1="exec sp_spaceused '?' "

However, I'd like to run it via sqlcmd. I've tried various
combinations of escaping the doulbe and single quotes but without
success.

sqlcmd -E -Q "sp_MSforeachtable @command1=\"exec sp_spaceused '?'\""
Sqlcmd: 'exec sp_spaceused '?'\""': Unexpected argument. Enter '-?'
for help.


Any ideas?

Thanks,

\M

[Back to original message]