Opps. See it was too early in the morning. All "nonaggregated columns".

Actually A is not fully true. For instance,

You can say

SELECT col1, col2, max(col3) from TableA GROUP BY col1, col2

Therefore col3 is not technically in the group by clause.

I could be...

Its a modifed version of MS. It has been working.

Sorry, Yes it is. Unfortantly, the log shipping has failed again so i am back to square one. However, you did bring up a good point that might be causing...

Nick, I do restore the file to the same server as where the undo file is. Perhaps I misstated earlier.

Jim, pretty sure there is enough dish space but you...

Yes, I have considered that this may be the problem. Why then would it work one time and not another. Thats what has me crazy.

No, just can't afford the down time. At least this business wants to keep it to a min. I am a newbie to administration so I am learning as I...

I am still perplexed by the message and I get from the script. Can not figure out why it would one time and not another. Strange!!!

Yes. It is.

I fixed it by restoreing it through the wizards. Very strange since the above code worked before. Thanks everyone.

The reason as I understand it is that if the main...

Thanks everyone for your help. I have figured out what was wrong and what to do. So it was an easy solution. Truncate the log and shrink the database was...

Is the correct way to turncate the log without saving

Backup LOG <dbname> Truncate_Only

Thanks for your help Kamlesh. Still not sure where I would write that script. Here is what I got.

1. Truncate the Vendor Table

2. On completion I have a connection...

How do you change the Data transformation properties dynamically?

Right now I select from a drop down from the table/view drop down.

I would like to accept a variable somehow?

Tom