>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.

>
>2- Do I understand that SQL Server counts ALL connections from one machine (or at least one VFP app) as "one user" in its licensing scheme? If that's the case, then I really don;t need to worry about having several connections open right? (at least not for licensing reasons)

This is going to depend on what type of licensing that you installed the server under. If you are using PER SEAT licensing, the workstation can connect to any number of server. For PER SERVER licensing, the workstation has a license to connect to a specific server. I thought it was driven by the number of distinct clients, not connections - but I could be wrong.

-Mike