Test transaction from command line

[MacFaza]

Hi!
Thanks for your help in advance...
I don´t have knowledge in SQL server, and i need to make a transaction (query) from a Windows 2000 command line, to know if the SQL server and its data bases are alive.
How can i do it ?
This will be a script running every 5 minutes.
Thanks
Gustavo
Gustavo Faza
gfaza@usa.net

 

[tlbroadbent]

You can use the SQL Server utility program, OSQL, from the command line. The options used will depend on the security model used in SQL Server, the nature of the query, and whether the program runs on the server or another PC. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[ccampbell]

YOu can write a script in Query Analyzer and then run osql from the command line using the -i option for input file. When you write your sql query in Query Analyzer save it and then on the command line type osql -ic:\tester.sql. This will launch that file and run anything in that file. Hope this helps

 

[MacFaza]

Thanks!
I will try it !
Gustavo
Gustavo Faza
gfaza@usa.net