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
Software/Hardware used:
ASKED:
October 11, 2012 9:55 AM