Re: Restore problem

On 12/28/2010 07:40 PM, Bob Pawley wrote:
>
>> Open the file in Wordpad and see if it looks better.
>>
>> I downloaded an sql editor and it looks the same in it as well.
>>
>> At least the editor will make it easier to fix the problem. However I
>> would like to know what happened so I can avoid it in the future.
>
> I am not sure. If the file is not to big and you wish you can send it to
> me off list and maybe I can figure out what is going on.
>
> The file is over 9 meg - way to large for me to e-mail.
>
> It seems that this has affected just the triggers - although that is
> quite massive I will just plug away at it until it's done
>
> Thanks
>
> Bob

The triggers or functions? The sample you showed was from a function. My
suspicion is that this is a line ending problem
(http://en.wikipedia.org/wiki/Newline) and is a matter of finding the
correct conversion utility.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com