getting the following error:
Messages
Component: Sessions
The following error occurred while collecting data
Incorrect syntax near '.'. [102] [Error Code: 102].
Table: Session List
Occurred: 10/10/2012 11:11:33AM
"Data is not being collected for this component"
Databases mostlkely communicated that tempdb was in 90 compatibility mode. Run the below code in your session query (edit where needed)
USE [master]
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'tempdb', @new_cmptlevel=90 GO
