Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Index Fragmentation for All Databases Expand / Collapse
Author
Message
Posted Tuesday, March 30, 2010 7:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 21, 2012 2:48 PM
Points: 8, Visits: 46
Hi,

I am getting syntax error. please see below...

Msg 102, Level 15, State 1, Line 14
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 14
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 14
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 14
Incorrect syntax near '('.
Post #892736
Posted Tuesday, March 30, 2010 4:37 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 8:19 AM
Points: 293, Visits: 813
The script is written such that the compatibility level all databases must be 90.

To check run
select compatibility_level from sys.databases
Post #893404
Posted Wednesday, March 31, 2010 9:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 21, 2012 2:48 PM
Points: 8, Visits: 46
100
Post #893910
Posted Wednesday, March 31, 2010 9:40 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 8:19 AM
Points: 293, Visits: 813
100 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.
Post #893914
Posted Wednesday, March 31, 2010 5:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 21, 2012 2:48 PM
Points: 8, Visits: 46
Hi Jon,

Still getting this...

Msg 102, Level 15, State 1, Line 14
Incorrect 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.
Post #894291
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse