Thanks Brian, that helps. In regards to locating files on separate drives are you saying that must be physically separate drives or can this be done in a RAID. I...

Andy, I set up a maintenance plan for one of my databases this weekend to see how it worked out. The selections I made within the package are as...

No power outages. No I didn't run the dbcc checkdb with repair option. Call it a rookie mistake. Not sure that would have fixed it though. No I don't run...

Yes, there are a lot of people utilizing the .mdb, however this package runs at a time in which no one should be logged in. Is there a way,...

O.K. I had the package log and here are the errors of have encountered. Any advice on how to handle these would be greatly appreciated:

ERROR 1

Step 'DTSStep_DTSExecuteSQLTask_7' failed

Step...

Andy, what would be the best way to utilize the triggers. I wanted to make a large table, say 75 colunmns and just shoot 1 line into the table...

quote:

---

When run manually it succeeds.

What happens when you run the DTS Package manually after such a job failure?

K. Brian Kelley

http://www.truthsolutions.com/

Author:...

quote:

---

What happens when you run the DTS Package manually after such a job failure?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide...

Thanks guys. I thought this might be the problem as it slipped my mind that VB creates com dll's. Thanks for the offer, but its time I got...

I'm using crystal reports 8.x and there is really nothing special about the reports. It does some grouping and summing, but nothing more. Its all handled in the report...

You are the man. So simple and I was so close. I went bald pulling my hair out last night. 🙂 Thanks Andy. Scott.

You're close...

Actuall I encountered it when I was creating a table using Query Analyzer. I was going to name a column type_name and when I type it, it turned pink...

Thanks for the response Steve, however I'm not sure you answered my question, or I am just not smart enough to understand 🙂 I'm not seeing the sp_execute and...

Thanks for the info. No, I am not having any issues, to speak of. I'm just looking for anything that can teach me to create well planned traces,...

Its not working. I have put all the data in the appropriate places and its not working. Just for fun I put a fake databasename in and it actually...