[dba-SQLServer] Cannot modify a query

You've got me on this one, JC. I have never seen that error before. Are you
able to rename the query? If so, you could then rebuild it from scratch and
all your other queries would still work.


On Fri, Nov 16, 2012 at 11:58 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> I have a specific query with the error "cannot find an entry with index 2
> on object with ID 41 in database with ID 14.
>
> I can open the query in design view, I can run the query and get data, but
> I cannot modify the query nor can I delete it.  It just happens to be a
> "base query" for a bunch of other queries and I need to modify the query.
>  I can take the SQL statement and save that as a new query and modify that
> but I cannot do any mod to the base query.
>
> So can I manually edit a table somewhere that stores the definition for
> this query?
> --
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
>
> ______________________________**_________________
> dba-SQLServer mailing list
> dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com>
> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver>
> http://www.databaseadvisors.**com <http://www.databaseadvisors.com>
>
>


-- 
Arthur
Cell: 647.710.1314

Prediction is difficult, especially of the future.
  -- Niels Bohr