InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 11:00:25 GMT20http://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspxHi Jon,Still getting this...Msg 102, Level 15, State 1, Line 14Incorrect syntax near '('.(0 row(s) affected)(0 row(s) affected)can you please copy and paste your script in the Article you posted, and run it in sql 2008? I hope you will get the same error as I got.Thanks.Wed, 31 Mar 2010 17:27:27 GMTvic610http://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspx100 should work just fine, it's really SQL 2000 (80) that's the issue.I use the script all the time on SQL 2005, SQL 2008 servers. If even 1 db is in mode 80 that's the error your typically get.Wed, 31 Mar 2010 09:40:42 GMTJon.Morisihttp://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspx100Wed, 31 Mar 2010 09:37:45 GMTvic610http://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspxThe script is written such that the compatibility level all databases must be 90. To check runselect compatibility_level from sys.databasesTue, 30 Mar 2010 16:37:29 GMTJon.Morisihttp://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspxHi,I am getting syntax error. please see below...Msg 102, Level 15, State 1, Line 14Incorrect syntax near '('.Msg 102, Level 15, State 1, Line 14Incorrect syntax near '('.Msg 102, Level 15, State 1, Line 14Incorrect syntax near '('.Msg 102, Level 15, State 1, Line 14Incorrect syntax near '('.Tue, 30 Mar 2010 07:17:05 GMTvic610http://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspxHere you go: [url=http://www.sqlskills.com/BLOGS/PAUL/post/Misconceptions-about-running-DMVs-on-database-with-lower-compatibility-levels.aspx]Misconceptions about running DMVs on database with lower compatibility levels[/url]Tue, 16 Jun 2009 13:42:22 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspxok - will do. It's lunchtime - nothing else to do :-)Tue, 16 Jun 2009 13:24:41 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspxNow that is interesting, didn't know what. Worth of a blog post.Tue, 16 Jun 2009 12:31:42 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspxYou don't need to use DBCC SHOWCONTIG for databases in non-90 compat modes. As long you run the DMV script in a database that's in 90-compat mode, it'll work fine against databases that aren't. Common misconception.Tue, 16 Jun 2009 11:15:31 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspxThis is pseudocode, but you could do something like this...if sp_MSForEachDB works in mode 65[code]BEGINCREATE TABLE #INDEXFRAGINFO--Create table structure based on result fieldsDECLARE @command VARCHAR(128) SELECT @command = 'Use [' + '?' + '] dbcc showcontig WITH ALL_INDEXES, TABLERESULTS, FAST'INSERT #INDEXFRAGINFO EXEC sp_MSForEachDB @commandSELECT * FROM #INDEXFRAGINFODROP TABLE #INDEXFRAGINFOENDGO[/code]Tue, 16 Jun 2009 11:03:35 GMTJon.Morisihttp://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspxIt would be great to have a version of this that works at compatibility level 65.Tue, 16 Jun 2009 10:19:13 GMTkevin-1084732http://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspxBe careful running a script like this that touches all indexes on all databases. Even though the LIMITED mode is only oging to read the level of the index above the leaf-level to get the logical fragmentation (I wrote the code inside SQL Server), running it over all indexes on all databases may do the equivalent of flushing out your buffer pool.A much better approach once you've got some knowledge of which indexes are your problem-children is to have a table with those indexes in and only check fragmentation on them - rather than everything in all databases. This does much less, and more targeted reads.If you don't have a clue about what the problem is though, this script is great.ThanksTue, 16 Jun 2009 08:18:24 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspxthe compatibility level all databases must be 90Tue, 16 Jun 2009 08:11:32 GMTJon.Morisihttp://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspxI had a syntax error. Is it just me???Tue, 16 Jun 2009 07:27:36 GMTMark Thabet-457565http://www.sqlservercentral.com/Forums/Topic731628-1563-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/67088/">Index Fragmentation for All Databases</A>[/B]Tue, 09 Jun 2009 10:25:28 GMTJon.Morisi