There are 3 ways around this:
-
Upgrade SQL to SQL 2005; it does have a join limit, but it is much higher than 260 joins
-
Rewrite the query to join a few of the views and write this to a temporary table, then join this to the other views
-
Query against the underlying tables or views (e.g. there is an account view). You lose the security filtering of filtered views, though with clever design you may be able to use a combination of filtered and base views. Not also that users will not have SQL permission on anything other than the filtered views
The first 2 are supported, but involve some work, whereas the 3rd option is probably the easiest but is unsupported