[dba-SQLServer] Cannot modify a query

did you move on from this one?  what version are you on now?  How are you
"editing" this query?


-Francisco
--------------------------
You should follow me on twitter here <http://twitter.com/seecoolguy>
Blogs: SqlThis! <http://bit.ly/sqlthis>  | XCodeThis!<http://bit.ly/xcodethis>

<http://db.tt/JeXURAx>




On Fri, Nov 16, 2012 at 8: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>
>
>