use strict;
use warnings;
use DBI;

my $dsn = 'DBI:ODBC:MSSQL';
my $user = 'user';
my $auth = 'pass';
my $dbh = DBI->connect($dsn, $user, $auth, { RaiseError => 1, AutoCommit => 1} 
my $sth = $dbh->prepare_cached("execute stored_procedure");