>We have one SQL SERVER 6.5 server. When we open Current Activity in SQL Enterprise Manager, there is nothing show there. Are there any set up will effect this?
>
>If we use sp_who, we get the information.
>
>Thanks
>
>
>Jim

I have seen this during a database backup or restore, but I don't know of any configuration settings that will do this. My experience is that the Current Activity display doesn't refresh very well, and can be misleading at times.

Leslie