in reply to Report Application Name to Enterprise Manager via DBI

Yes. It's not a function of DBI: it's stored in the catalog, in the master database. You can retrieve it with a regular query.

I don't recall the exact field name, but the easy way to get it is to look the text of the sp_who stored procedure. IIRC, sp_who itself is in the sybsystemprocs database.

Replies are listed 'Best First'.
Re^2: Report Application Name to Enterprise Manager via DBI
by jfroebe (Parson) on Jun 09, 2004 at 16:07 UTC

    Actually they are logical tables.. a series of memory structures within SQL Server.. it just appears as tables. master..sysprocesses is just one such table.

    Jason L. Froebe

    No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1

[reply]

In Section Seekers of Perl Wisdom