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
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
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