use DBI; my $dsn = "Provider=sqloledb;Trusted Connection=yes; Server=$databaseHost;Database=$databaseName"; my $sqlDBHandler = DBI->connect("DBI:ADO:$dsn", $databaseUsername, $databasePassword, {RaiseError=>0,AutoCommit=>1}); my $sqlStatement = 'EXEC GenerateNewPickConfirmationMessage'; my $sqlSelect = $sqlDBHandler->prepare($sqlStatement); $sqlSelect->execute; $sqlResult=$sqlSelect->dump_results(); $sqlDBHandler->disconnect;