jwcolby
jwcolby at colbyconsulting.com
Wed Nov 28 15:07:58 CST 2012
No, I am talking about the query itself, not the data. I tried to add something (a field I think) and it allowed me to do so until I tried to save the changes, and then SQL Server threw an error. Tried to copy the SQL to a new query and save, that worked. Dried to delete the old query, SQL Server threw an error. So I have a query which works (can pull data) but cannot be modified or deleted. John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it On 11/28/2012 3:45 PM, Martin Reid wrote: > 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 > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >