[dba-SQLServer] [SPAM] Re: Cannot modify a query

jwcolby jwcolby at colbyconsulting.com
Wed Nov 28 14:42:07 CST 2012


I have not resolved this.  The database appears to be corrupt.  I can edit and run it but cannot 
save edits nor delete the query.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 11/28/2012 2:04 PM, Francisco Tapia wrote:
> 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>
>>
>>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>



More information about the dba-SQLServer mailing list