SQL Server Performance

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

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Mar 17, 2008.

  1. Anonymous New Member

    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">
  2. Anonymous New Member

    Pingback from sql error 102

Share This Page