Posted by Erland Sommarskog on 11/22/07 08:20

Desmodromic (davies_ms@yahoo.com.au) writes:
> 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.

Try:

sqlcmd -E -Q "sp_MSforeachtable @command1='exec sp_spaceused ''?'''"

In SQL you use ' delimit strings. " may also work as a string delimiter,
depending on the setting QUOTED_IDENTIFIER, but as this setting is normally
on, stick to ' and double it when nested.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Finding the user who do update in Query Analyser?
• Prev in forum: Re: Launch storedquery for each record
• Thread view: Re: sqlcmd and escape characters

[Reply to this message]