September 8, 2006 at 2:11 pm
I have an existing d/b (sql 7) w/ many tables views stored procedures etc. The database is backed up every 2 weeks.
Some data started dropping from our Crystal reports. I have determined if i update the view (from w/n Crystal) to the backed up view; the data shows... leading me to suspect something has become corrupt in my current view.
I thought I'd copy the old into the new; but that doesn't seem to be doable (??!); so instead I created a new view and intended to cut/paste the query definition into the new ... rename etc.
The definition is 17 printed pages long and I don't seem to be able to paste it all back into the definition. Furhtermore, when I try to save the new query (i thought I'd save it in pieces) it get an error (i imagine because it isn't complete) and the view won't save.
help?!
Thansk
kh
September 8, 2006 at 6:26 pm
Are you altering the view using query analyzer, enterprise manager,...?
What error do you get?
September 8, 2006 at 10:15 pm
Right click on the view and generate script. Then copy the scrpit and run it in query analyzer.
Hope this helps
Thanks
Sreejith
September 12, 2006 at 1:17 pm
Thank you for your response;
When I try to do this, it doesn't accept all of the characters. There seems to be a limit as to how much the buffer can accept (I have verified the whole script is being copied).
September 12, 2006 at 2:53 pm
See if there are dependent objects generated. In that case you can execute the script per object.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply