Error while executing DMV - Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '('.

DMV - has got very special place for DBAs since the inception of SQL Server 2005. In this case one of the thme is very important to find out the index statistics within your database, such as sys.dm_db_index_physical_stats statement. Recently one of the user complained about running DMVs on a specific SQL Server instance where the error was generated as follows: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '('. So the first one to check is to ensure they are using correct syntax during...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2008/03/17/error-while-executing-dmv-msg-102-level-15-state-1-line-3-incorrect-syntax-near.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3820" width="1" height="1">

Pingback from sql error 102