quick test of stored procedure???

[hinchdog]

Do anyone know how to do I quick test of a stored procedure to make sure it's working. I'm referring to SQL server 7.0. Thanks!

-Hinchdog

 

[foxdev]

I guess the obvious answer we're all thinking is: run it.

Alternatively, you can click the Check Syntax button on the EM dialog, or the check button (the check mark icon) in Query Analyzer. It is not a fool-proof check, since it really only checks sytax. Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org

 

[hinchdog]

I should have explained further, my bad. I acually have it on a schedule of every three hours. The syntax checks out fine, but it's not doing what it's supposed to. I thought maybe you could force it to run immediately. Like a "run" command or something. Maybe this is very stupid of me to ask, but I extremely new.

 

[foxdev]

Its not stupid to ask, that's why we're here - but this is pretty basic. You should look through Books Online (BOL) as your first step.

Start Query Analyzer from your Windows SQL Server program group, connect to the server, change to the correct database, then type in the name of the stored procedure and click the Execute button.

You can also force a SQL Server Agent job (the thing that is scheduling your stored procedure) to run by right-clicking on the job and choose Start Job. Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org

 

[hinchdog]

thanks. i'll check out BOL. god speed!