> Hi guys,
> I've got two questions I'd appreciate help with...
> (1) If / how, using JDBC, can one set the value that appears in sp_who2's
> "ProgramName" column?
This would be driver-specific, as the program name is not generic to JDBC or
DBMSes. In the case of the MS driver, you cannot do this.
Quote:> (2) If / how, using JDBC, can one detect that a stored procedure invocation
> in JDBC was terminated using T-SQL's "KILL <spid>" command?
Impossible. Once the DBMS kills the connection, the JDBC driver will only find
out by failing to accomplish what it tries next, and it may not even see or be able
to parse anything sent to the client by the DBMS, which is usually nothing anyway.
Joe Weinstein at B.E.A.