;-)

Yes. in my stored proc

..bunch of code..
COMMIT TRAN
SELECT @id
[download]

and then in my script

my @id = $sth->fetchrow_array;
return $id[0];
[download]

does the trick. Many thanks.