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...

No idea....

In general, triggers should not start jobs, send email, launch applications or anything of the sort. A trigger should be doing small data verifications or changes, nothing more.

😀

As I mentioned over at SQLTeam, you may want to give CSS a shout. If no one's answering it's most likely because they don't know.

Ok, so you need the users, with their database and server roles and with the permissions that they have directly on database objects.

One database or all?