Running Transac SQL in Command Line

Hi all

I currently have a problem where I need to create a backup from MSSQL, via a command line, ideally from a batch script. This is on a PC. Each machine has SQL Server 2000 on.

I just need to know the code that dos will tell it to run the sql statement. Ideally the command will also give the directory to place the backup.

Regards MiloJFunny that you should ask! There is a KB article just for you, #241937 (http://support.microsoft.com/default.aspx?scid=kb;en-us;241397) that describes in detail just what you want.

-PatP|||Pat, that's perfect you are 100% on the money, much obliged