SQL Feeds - All your SQL feeds in one place.

Sponsors

Thursday, May 07, 2009

SSMS Error possibly related to database compatibility mode

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 5/7/2009 9:55:00 AM

I've seen (and heard of a few other cases where people received) the following error:

Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

And, the problem (when I got this error) was the compatibility mode of the database I was in didn't support what was being attempted. In SQL Server 2005, the reports used to generate an "Incorrect syntax near '('." error. For what I was trying to do (execute/access some of the standard reports from within SQL Server 2008 Management Studio), I received this error and immediately thought it might be the compat mode. Sure enough, it was.

So, I don't know how often this will help you but just in case - I thought I'd post this!

Cheers,
kt

email it!bookmark it!digg it!

Original Post: SSMS Error possibly related to database compatibility mode

Legal Note

The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us