Basically, I have perl script.  This perl script executes a stored
procedure on Microsoft SQL server 2000.  The problem is this...
depending on what goes on in the stored procedure, not all of it will
be executed by perl, and no error will be reported.

Observe:
1.  Create a stored procedure:
----BEGIN SQL Code

as
SET NOCOUNT ON
truncate table geofftest




BEGIN
        print '1234567890123456789012345678901234567890123456789012345678901234567890'
        select * from geofftest

END

------END SQL code

2.  Run this from the query analizer window:
exec sp_geofftest 'one', 'two'

3.  Now check to see that both values got inserted into the table:
select * from geofftest
The result set will contain both values, 'one' and 'two'

4.  Now, run this perl script:
-------BEGIN PERL CODE
use DBI;
$DSN = 'DBI:ODBC:DSN';
$USER = 'user';
$PASS = 'pass';
$DB = 'db_name';
#Connect to DB
my $dbh = DBI->connect($DSN, $USER, $PASS, { PrintError => 1,
RaiseError => 1, AutoCommit => 1 });
#Call Stored Proc
my $statement = "exec $DB.dbo.sp_geofftest 'one', 'two'";
print $statement."\n";
my $sth = $dbh->prepare($statement );
$sth->execute;
#clean up
$sth->finish;
$dbh->disconnect;
------END perl code
Note that no error are returned when running this code...

5.  Now check to see (again) that both values got inserted into the
table:
select * from geofftest
The result set will contain only the first value!!!! ('one')

I have tried different drivers (ADO, W32ODBC) and get the same
results.  Am I doing something wrong with my perl code?  Or is it a
driver/odbc issue?  If anyone has any insight, I would greatly
appreciate it.

Thank you,
Geoffrey Nix

while( my $h = $sth->fetchrow_hashref() ){
        ; # you might want to  dump  $h

Hope This Helps
Andrea