troubleshooting Question

SQLCMD Syntax

Avatar of Mauro Cazabonnet
Mauro CazabonnetFlag for United States of America asked on
Microsoft SQL Server
2 Comments1 Solution253 ViewsLast Modified:
I'm trying to run a sqlcmd as follows

If I append say PRINT 'TEST' to the @command it errors out

What am I missing?

DECLARE  @command VARCHAR(256) 
DECLARE  @CommandText VARCHAR(512) 
DECLARE  @SQLCMD VARCHAR(64) 

SET @SQLCMD = 'SQLCMD -SLocalHost -E -Q ' 
SET @command = ':CONNECT SERVER1' 

SET @CommandText = @SQLCMD + '"' + @command + '"' 
PRINT @CommandText 

EXEC MASTER.dbo.Xp_cmdshell @CommandText

GO 
ASKER CERTIFIED SOLUTION
Mauro Cazabonnet
Senior Windows Automation Developer
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros