[dba-SQLServer] The problem is the query, not the data

JC,

Presumably when you say "saved query" you mean View. Not sure why you're
having problems modifying it, but you could try this approach instead and
see what you get:

Right-click on the View and generate its Create script to a new query
window.
Change the CREATE keyword in the script to ALTER.
Make your changes to suit.
Execute.
Inspect the results.

HTH,
Arthur


On Mon, Feb 25, 2013 at 10:16 AM, David Lewis <David at sierranevada.com>wrote:

>
> Not sure what you mean by 'save the query'...
> If it is a view, you can script it as 'Drop And Create...' to a new
> window.  You can manually execute any of those statements (first the drop,
> then modify it as needed, then create it again) as you need to.
>
>
>
> Message: 1
> Date: Wed, 28 Nov 2012 16:07:58 -0500
> From: jwcolby <jwcolby at colbyconsulting.com>
> To: Discussion concerning MS SQL Server
>         <dba-sqlserver at databaseadvisors.com>
> Subject: [dba-SQLServer] The problem is the query, not the data
> Message-ID: <50B67D2E.1060503 at colbyconsulting.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> 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?
> >
> >
>
>
> The contents of this e-mail message and its attachments are covered by the
> Electronic Communications Privacy Act (18 U.S.C. 2510-2521) and are
> intended solely for the addressee(s) hereof. If you are not the named
> recipient, or the employee or agent responsible for delivering the message
> to the intended recipient, or if this message has been addressed to you in
> error, you are directed not to read, disclose, reproduce, distribute,
> disseminate or otherwise use this transmission.  If you have received this
> communication in error, please notify us immediately by return e-mail or by
> telephone, 530-893-3520, and delete and/or destroy all copies of the
> message immediately.
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
Arthur
Cell: 647.710.1314

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