We used this system at Phillips Petroleum when I was there in the 80's.

The one year I got ranked a 5 my manager said next year he would give it...

Great article, thanx.

Assuming the data to load is sorted, can anyone tell me which is quicker when loading a table with a clustered index; 1) With the index defined and...

I have a BS and MS in Geology from back in the mid 70's. I worked as a field geologist for 3 years drilling for coal. Fall and...

Here's another reason why we should have a PK. We have a large vendor database we want to replicate for reporting purposes. We wanted to use transactional replication...

I am running from the server so there was an O drive.

However, as it turns out I found a different way to run the job without a runas command.

Thanx everyone...

Thanx for the input but it didn't help.

I uninstalled the security and retested but got the same results.  In the event log I saw the following error again and in Task...

Everybody brings up alot of good points and suggestions and I appreciate the help and will move forward with some of them.

I am still open to other ideas so if...

I just applied service pack 4 and when I right click on a job and select start job, the dialog box comes up in step name order, not step id?

Anybody...

I too have experienced both kinds of the projects described in the article.  I too have found that rarely does one approach work and a combination of the approaches ultimately seems best. ...