>>1 - on the Activity-Process Info screen - there doesn't seem to be a way to refresh when I add or drop conenctions. I have to reopen. Is that designed behavior?
>
>The enterprise manager takes a snapshot of the activity. You'll have to periodically refresh the Current Activity folder to see any changes. You can also retrieve connection information using the sp_who and sp_who2 system stored procedures.
PMFJI, but how do you refresh the Current Activity folder? I'm having the same problem Ken described - having to reopen Enterprise Manager to get the 'really' current activity. I want to be able to see connections come and go - I don't mind hitting the refresh button or something, but that doesn't seem to work.
TIA,
Beth Wetherbee, MCSD
VBCPS