Alot of us who are concerned with specific databases becoming corrupt and unusable usually also do a transactional replication to copy the data to another site for safety sake.

"Don't roll...

Use GROUP BY and you column even if not in the select list is fine. Just keep in mind anything not in an Aggregate function such as SUM, MAX, MIN,...

I have moved serveral million records is a single pacakge execution and have never seen this. If is an app the app may be having a problem finding the DTS...

Generally I would follow the rule of total amount available to all instances as 90% with a minimum of 64-80 Mb for the OS.

So depending on what each instance...

Sorry couldn't offer a better option.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

This is a variation of what Sven wrote that seemed more like what you were looking for. However I do not agree with the cursor statement as the while has...

Ok, I am baffled primarily since the sqlsp.log file does not containt a failed line. My last thought is find the .out files that occurr when the upgrade is done...

Right, this is because the DTS activex com objects do not exist on the computer A in question. You will have to install them which I am not sure if...

I agree with crosspatch. DTS is far more flexible it creatigna structured file liek you are speaking out. BCP does not allow direct output of the column names as headers....

This is one of the hardest things to do and I personally have not seen a third party tool that does all that much better (anyone seen one?). Anyway the...

Also I see you are doing a lot of work that is not needed with memory. Below I have posted what I would have done with the trigger that fixes...

One of the main reasons I don't use it is the fact I use differential backups most of the time which I have coded to do the differential nightly Sunday...

quote:

---

I thought that view object is only the structure

---

Right.

quote: