sqlcmd :0 rows updated
When I run exec dbo.subprogram from sql server management studio, it executes and returns result as many rows affected: But when I run from cmd C:Usersmssadmin>sqlcmd -S servername -d databasename-q “EXIT( exec dbo.subprogram)” it retunrs as 0 rows affected. What could be the problem

Answer Question   |  October 11, 2012  9:55 AM
SQLCMD

SQLCMD does not create a log file
I have several SQL update/delete statements I run during a payroll cycle. When I run a SQL that does not have any records that meet the selection criteria, I do not get a log created. I can run the same SQL in SQLServer, and it shows (0 records updated).

Answer Question   |  January 21, 2011  5:52 PM
SQL Log Files, SQL Records, SQL Server, SQLCMD

Using the return value of a SQL Restore script
I am trying to use the return value of a SQL Restore script executed with SQLCMD, so that my batch script can report on the succes or failure of the restore. I am having difficulty getting the script to return the result of the backup or restore process. Do you have any suggestions? The follwoing [...]

Answer Question   |  March 20, 2009  5:34 PM
SQL Restore, SQL Server, SQLCMD