in reply to Find the status of the execution for stored procedure/SQL query using Perl
Surely the MSDN docs would tell you :)
You can use the standard DBI with DBD::ADO - A DBI driver for Microsoft ADO (Active Data Objects)