Skip to content

Instantly share code, notes, and snippets.

@groovyghoul
Created September 10, 2014 19:10
Show Gist options
  • Save groovyghoul/2ceed07e31914bf6e647 to your computer and use it in GitHub Desktop.
Save groovyghoul/2ceed07e31914bf6e647 to your computer and use it in GitHub Desktop.
Interbase active connections
select a.TMP$STATE, a.TMP$USER, a.TMP$USER_IP_ADDR, a.TMP$USER_HOST, a.TMP$USER_PROCESS
from TMP$DATABASE d join TMP$ATTACHMENTS a on d.TMP$DATABASE_ID = a.TMP$DATABASE_ID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment