regarding db update

hi sir,

how to create a job step using sql server management studio. give one example snap shop of how to create.it will be helpful to me.....

sir

i am facing the problem that how to create a bat file......please help me

A bat file is just a text file with a ".bat" extension instead of a ".txt" extension. So create a text file and rename it to have a .bat extension.

what should be there inside a bat file.

Give Some Video tutorial for doing the database update in wybuild

What database are you using (MySQL, MS SQL, etc.)? Did you use the appropriate commandline utility to update your database? Is your SQL script valid?

Am using ms sql2008 and my scripts are valid script only.still i cant able to get the concept of creating the command line utility after reading the link you gave.so if any video tutorial is there means it will be very helpful to me.

please give if any video tutorial

A video tutorial wouldn't help. It would basically be a bunch of text that wouldn't be able to select -- which is pretty useless.

Since you're using the Microsoft SQL Server, you'll need to use the sqlcmd utility to update your database.

Step 1: Open cmd.exe on your computer.Step 2: Run sqlcmd.exe. Can it be found? If not, try specifying the full path (like %programfiles%\MS SQL\sqlcmd.exe or something like that)Step 3: Read the sqlcmd utility article to learn how to update your database using a simpe SQL script.Step 4: Once you've got the sqlcmd thing all figured out, copy the line you typed into the cmd window and paste that into and emtpy *.bat file. This is the bat file you'll be including in your update.

I don't usually butt into threads... but I just had to say that Sam sure has the patience of a saint.

😀

I don't usually butt into threads... but I just had to say that Sam sure has the patience of a saint.

@MarkLIC I wholeheartedly agree. There's no way I would have made it through. 😲