InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 11:34:11 GMT20http://www.sqlservercentral.com/Forums/Topic469908-360-1.aspxProbably compatability mode. What do the following queries return?SELECT @@versionexec sp_dbcmptlevel < Name of the database you're in >Sun, 16 Mar 2008 06:58:01 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic469908-360-1.aspxHuh, it works just fine for me.Are you sure the is SQL Server 2005? Is the database possibly in compatibility mode=80?Sat, 15 Mar 2008 17:16:59 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic469908-360-1.aspxFYI, you have to quote the color, "red" in the color tag.Sat, 15 Mar 2008 17:12:13 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic469908-360-1.aspxHi guys, I am executing this query in the query analyzer 2005.I am the sysadmin to the server.when I executed this query it errored with a syntax error as highlighted in red . please help mesyntax error Server: Msg 102, Level 15, State 1, Line 13Incorrect syntax near '.'.select top 10 qs.sql_handle, qs.execution_count , qs.total_elapsed_time, qs.last_elapsed_time , qs.min_elapsed_time, qs.max_elapsed_time , qs.total_clr_time, qs.last_clr_time , qs.min_clr_time, qs.max_clr_time , substring(st.text, (qs.statement_start_offset/2)+1 , ((case qs.statement_end_offset when -1 then datalength(st.text) else qs.statement_end_offset end - qs.statement_start_offset)/2) + 1) as statement_text from sys.dm_exec_query_stats as qs[b][color=red] cross apply sys.dm_exec_sql_text(qs.sql_handle) as st[/color][/b]Sat, 15 Mar 2008 16:37:05 GMTjaiganesh-489973