When we remotely manage a SQL 2008 instance the Database column in Activity Monitor is Blank, but when connected directly it shows up. We do have one user where the database column dose populate but he cannot remember if he did something to fix/enable it
or not. These users are logging into this SQL server to get this info instead of managing remotely which I would like them to stop doing but I need to resolve this before they can since this info is critical.
I cannot imagine it is permission related since the column is blank for me as well and I have sysadmin rights over the instance.
Lossless Audio Addict
View Complete Post