Great suggestions! I will definitly be giving this a try. Thanks for your help!

Ken

Thanks for the info. This is a MSDE 2000 instance, the server has one processor and they want to put another one in.

Ken

Thanks for your help with this, I added my login to the local admins group and I still could not get access. I am thinking someone did delete the builtin/admin....

That was some time ago and I believe we installed SP4 and the problem went away. Have you given sp4 a try?

Ken

Thank both for your response, I will check for the DTSRUN command, and follow your instructions. Thanks again.

Ken

I have to agree with the concept of a connection between music and the IT world and I would be willing to bet most technical based careers have a higher...

My system is also a sharepoint system that was growing the tlog so fast it filled the disk in about 2 days! A 20 gig tlog file was not unusual!...

Ok thanks for you reply, I think I got it fixed, I had to recreate the job and it seems to be running fine now.

Ken

Yes we only have one dup per row. I guess we lucked out this time!

David thank you for the article, we will have to give it a try,

Ken

Thanks Matt,

Your soulution is kind of what I was thinking, I just planned on creating a new table and putting in everything sans dupes and primary key, figured to create...

Thank you for your reply, will give it a look.

Ken

Jeff,

Thanks for your response, the user does not care, I would think the smaller would do. I was told the numbers in the primary key are not referneced in the...

Thanks for all your help!

Kobus,

Microsoft suggested we look into a hardware problem. We ran diagnostics on our disks and found one maybe two to be 'going bad' after replacing the disks and adding the...