December 2, 2009 at 2:48 pm
Hi every one,
how to run this script in CMD
sqlcmd -S %myS% %myU% -d %myD% -I -i pAlert_MilestoneExpired.sql >> _Deploy.txt 2>&1
December 2, 2009 at 3:04 pm
You could put it in a .BAT file. You could create an executable in .NET Studio that would run it. You could have it run by xp_cmdshell from an SQL script or proc. Lots of options. Really depends on exactly what you're trying to accomplish with it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 2, 2009 at 7:04 pm
Thank you for the reply...
There are series of scripts like this and i am using this scripts(existing) to create a deployment command file for the tables i have created.
well i have been told to do that with existing scripts(by just replacing the table names ) which are stored with .cmd extension in a folder .when i right clicked on that file and opened it, the scripts ran in command prompt.i don't know weather the scripts ran .please tell me by right clicking the .cmd file will run the scripts or not?
December 3, 2009 at 6:55 am
No clue.
Set up a test script. Make it one that does something really, really obvious that you can test for. Then try it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 4, 2009 at 11:56 am
itskumar2004 (12/2/2009)
well i have been told to do that with existing scripts(by just replacing the table names ) which are stored with .cmd extension in a folder .when i right clicked on that file and opened it, the scripts ran in command prompt.i don't know weather the scripts ran .please tell me by right clicking the .cmd file will run the scripts or not?
If you right click and select Open the script will run. You have to use right click and Edit to modify the .cmd file.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
December 4, 2009 at 12:33 pm
Thank you very much..................
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply