Hi Friends,
I am using sql 2008 express edition.
I have sql statements.I want to schedule those sql statements through batch file.
sql statements-sqlProcess.sql
USE [Marine_STS]
insert mstplant(pCode,pUserCode,pName,pShName) values (4,4,'p','p')
GO
batch file contents
sqlcmd -S WIN-MR3EVT3JRRM -U marine -P marine -i D:\IHITS\temp\Rajeev\SCHEDULE FILES\sqlProcess.sql
This is not working in server.
What I have tried:
I have tried in local system.Its working .but not working in server