Martin Reid
mwp.reid at qub.ac.uk
Wed Nov 28 14:45:06 CST 2012
John This help http://support.microsoft.com/kb/822747 Sent from my iPad On 28 Nov 2012, at 20:43, "jwcolby" <jwcolby at colbyconsulting.com<mailto:jwcolby at colbyconsulting.com>> wrote: 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<mailto: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<http://databaseadvisors.com> <dba-SQLServer at databaseadvisors.com<mailto: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<mailto:dba-SQLServer at databaseadvisors.com> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com<mailto:dba-SQLServer at databaseadvisors.com> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com