Sure. They can work fine together. Make sure you install 2000 first.

Please don't use polls unless you are actually posting a poll.

What's the question?

Keep a copy of the old proc, under a different name, and you can run them both to check.

I've often used Excel to compare two resultsets. Put each resultset...

When you say "update is not working", what exactly do you mean?

Throws an error?

Runs forever?

Updates no rows?

Something else?

On the first execution, the statement has to be complied and optimised. The optimiser will optimise all of the queries in the proc, regardless of whether or not they can...

Tom Brown (12/1/2008)

---

And I see you're in South Africa too - So its early summer there? which just reinforces how f.f.f.f.freezing cold it was for me cycling into work...

Why the app lock? What's that for, and could that be the cause? If lots of other procs are alse using applock, it could take a while for this one...

If you run the contents of the proc in query analyser, of the insert, update and select, which one is the slowest?

You could use the SSIS transfer jobs task (on the 2005 server) to pull the jobs over.

What about transaction log backups? If you're not doing any, there's your problem right there.

If you're not doing log backups, take a look through...

Depends what you're doing.

Usually derived tables are less intensive because there's no interim storage and no need to insert stuff somewhere and then query it out. If you're doing...

There's an idea. We promise we won't break anything....

(I need an angel with halo smilie - innocence)

Steve: Are you...

Tom Brown (11/28/2008)

---

There is room in a post title to show the time of a post in the poster's local time, as well as in GMT (or is it only...

Knowing where you are based in the world would be useful.

Yup. I was posting at 1am the other day, though I doubt anyone would have noticed...