Thanks for your help Andy. I along with the developers suspected it had to do with the CF / OLEDB interaction. It's a new version of CF, and they have...

Hi Andy,

FYI - We are using TCP/IP as the default connection on all servers and workstations. Also we have MDAC 2.6 SP1 installed on our servers.

Jason

Hello everyone,

Well, stupid errors sometimes get you into trouble and this was one case where it did. When I created the file, I added the ".txt" extension, but my machine...

Thanks everyone for your input !! I'll let you know what we build in the coming weeks.

Jason

Paul and Andy,

Thanks for the replies. I should have said that I was using SQL 7 because the DTSRUN utility doesn't support the /A until SQL 2000....

Most of the front end applications are Cold Fusion applications. The remaining would be VB and Access apps. The number of concurrent users is somewhere in the several hundreds.

Jason

Well, I don't know what happened, but if you close EM and then open it up again, everything seems to work fine. Must be one of those undocumented features!

Jason

Steve,

Would you please explain the concept of "stage" databases. Also, I thank everyone for their input. I'm glad I'm not the only one who has to deal with these...

Thanks for the correction! I'll try that next time to see if it works. BTW - Is there an easy way to get the id of the user who owns...

I tried executing the stored procedure and I got the following error message:

Server: Msg 8114, Level 16, State 4, Procedure sp_reassign_dtspackageowner, Line 0

Error converting data type varchar to...

Andy,

The backups aren't taking a lot of time to do. They are 4 semi-large tables that hold read-only data from the mainframe. We have tossed around the idea of putting...

quote:

---

I know what you mean about too many indexes, seems its always too many or too few, never just right! Do you...

Hello all,

Andy, I liked your article. I think it is important to have PKs on tables in order to maintain data integrity. I also agree with the individual who said...