Specifying WITH ROWS in CREATE STATISTICS statements is not supported when you run SQL Server 2008 set to the compatibility ...

Specifying WITH ROWS in CREATE STATISTICS statements is not supported when you run SQL Server 2008 set to the compatibility mode of 90 or later. Modify CREATE STATISTICS statements that include WITH ROWS by specifying WITH SAMPLE number ROWS, or by specifying other options that comply with the documented syntax. For more information, see the topic "CREATE STATISTICS (Transact-SQL) in SQL Server Books Online.