Microsoft introduced security changes starting in SQL Server 2005 which have made it more complicated for Forecaster's Current Users List (View | Current Users List) to interact with SQL Server. Anyone who tries to use this screen will see only themselves listed.To make this screen work, users with the need to utilize the screen need to be granted permission within the SQL Server. To do this, have a dba or other authorized person follow these steps to grant the VIEW SERVER STATE permission within Microsoft SQL Server 2005 or Microsoft SQL Server 2008:
Supported videos include:
Easily create a Forum Website with Website Toolbox.