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
Navigation:
[Reply to this message]
|