Thanks, Michael

Paul

Hi Michael

Thanks very much for your reply.  My table tblStaff is drawn from the Personnel system on another SQL Server.  I have already implemented your suggestion - and am very...

Hi Greg

Will do.  Many thanks for all your help.

Paul

Thanks for the replies.

Greg,  I have chosen to execute the Package Name - so that, I guess, is not the problem.  How do I turn on logging for the child...

Hi

Thanks for replying.  The table remains dbo.

The DTS package is now working again??  On Friday it was returning a primary key conflict - as if the SQL was trying to...

Thanks to both of you. 

Excellent solutions.  I found the ADO worked best for me for this particular problem and can now do what I needed to do.

This is much...

Many thanks for all your help, Steve.  Maybe I'll eventually find the prob...

All the best

Paul

Thanks, Steve.

I can't work this one out either.  Are you using SQL Server 2000?  Enterprise Manager (Microsoft Mangagement Consol 1.2 v5 Build 2195 Service Pack 4 ??

Regards

Paul

Hi Steve and Alamir

Thanks so much for your help.  I now have it working.  Although I still have a question:

When I choose a backup set from the list in Enterprise...

Hi Steve

Thanks very much for your help.

CM is the name of my database.

What I have done (all in Enterprise Manager) is to create a two devices:

CM_DB

CM_Log

CM_DB is backed up...

Thanks Alamir

Maybe its me, but I can't find a logical way forward from BOL.

What SQL Bill has described is, I guess, run from Query Analyser.  Can I restore a logfile in ENTERPRISE...

Hi SQLBill

Thanks very much for replying.

What you have described is, I guess, run from Query Analyser.  Can I restore a logfile in Enterprise Manager without incurring the error message I...