Perfect! Thank you so much!

I tried your script and get and error saying the request to stop the job was refused because the job is not currently running.

Seems like the mystery runs deeper than...

Great info! I ran that on both jobs and found that they only have one entry from when it started. There is no (Job outcome) entry.

I will check on the...

Wow! That was fast!

I will try those and update with the level of success.

Thanks!

You will most likely get an answer sooner if you post the question to a Terradata forum. This is an MS SQL Server forum and it does not typically...

You are going to have to get more specific as to what you are looking.

"SET ROWCOUNT" is a global setting. Not to be used unless you want to limit every single query executed.

Use TOP:

UPDATE TOP (10000) ...

I would look into a tool such as the Red Gate SQL Monitor to do what you are looking to do. Very slick and efficient.

It would be best for you to find a forum specific to fisql. This is a Microsoft SQL Server forum.

If there is no index on the URL column on the table you are pulling the data from then you will probably end up with a row by row table...

What error do you get when you try to uninstall SQL?

Is it possible that the VS uninstall is still marked active? Especially because you mention that the uninstall was...

Sounds like homework to me.

You are not using the primary key in the join between the SOURCE and TARGET. Your primary key also looks to be a more or less sequential value.

Neither of...

Thanks! That is pretty much what I was thinking. However, I do get surprised once in a while.

What value are you using for fill factor?