I found a cool utility for running stored procs via the command prompt:
http://blog.bartholomew.id.au/index.php/2005/07/24/nsqlsp-utility-to-easily-run-stored-procedures-from-the-command-line/There is often the need to quickly run a stored-procedure from the
command-line because you don’t have access to Enterprise Manager or Query
Analyzer (especially when working with MSDE). Sure, you could use osql.exe to
run the stored-procedure, but what if you can’t quite remember what parameters
the stored-procedure takes or can’t quite remember the name? Well this is the
hole that nsqlsp was designed to fill. It comes in particularly handy for
calling system stored procedures (such as sp_addlogin).
Thanks to William Bartholomew
No comments:
Post a Comment