From: web12master@gmail.com   
      
   Hello,   
      
   I've been trying to run this sql:   
      
   SELECT b.fill_factor, b.type_desc, a.index_id, b.name,   
   a.avg_fragmentation_in_percent, a.avg_page_space_used_in_percent   
      
   FROM sys.dm_db_index_physical_stats ( DB_ID() , NULL, NULL, NULL, NULL) AS a   
      
   JOIN sys.indexes AS b ON a.object_id = b.object_id AND a.index_id =   
   b.index_id;   
      
   We have few database on our server.   
      
   On most of them this sql statement works fine, but on few of them I got   
   error   
      
   Msg 102, Level 15, State 1, Line 8   
      
   Incorrect syntax near '('.   
      
   What could be a problem?   
      
   I don't get it? The statement is exactly the same, once it works fine, next   
   time there is error?!   
      
   Thanks in advance   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)