I decided to just call the offending sp with osql (which works in all respects). Thanks!

Stupidity.  🙂

Curious. No error code, *and it got a userid*, but the tables have *not* been written to.

Perhaps the last select needs to be put after the transaction commits, so...

The perl generates the parameters for the SP (which I can see because $db->Run($sql) dumps it to STDOUT) and when those parameters are fed to the script in QA, it...

Thanks, I'll try it. It leaves a question hanging, though: the tables are only updated when the SP is run in Query Analyzer, or when the perl is stepped...

Yes, and also inserts properly.

Sure. Here goes:

THe perl:

my $sql = "EXEC dbo.addApplication "; # Don't take the space out. It matters.

foreach $key (sort keys %$ref ) {

# print...

It fetches and there's nothing in the row.

No. The script generates its own saying it didn't get the userid, but that's it.

New, amplifying data: if I step through the script in the debugger, it succeeds. ...