Also I've tried setting TRUSTWORTHY on for both DBs that need to talk to each other but it still fails.

I'm not using EXECUTE AS though as there is one login...

Thanks for that. I've decided to do it a totally different way now anyway but its good info to know for the future.

The tech lab rats say they have defraged the hard disk and its down to 0%.

However I ran the script again and it made no difference. I picked one table...

I have just asked someone to take a look at the phyisical hard drive that the dev server is on and they

say it reports 97% fragmentation which isn't good. We...

The page count ranges from 2 to 77.

It seems that those indexes that have pages > 20 (roughly) are having re-organises carried out against them whilst the indexes with smaller...

I am running sp_updatestats at the end of the proc.

I was thinking that as its on the dev box there might be an issue with the actual hard drive being...

There are 2347 rows in this table.

Looking at some of the other tables that no change in the frag % it does seems that the majority are all

in the 50...

Thanks that did the trick perfectly!

OK I agree with you and thanks for your input.

Does anybody ever bother reading the original posts before replying to messages? Notice in the original question I said "I know I could use a stored proc", I didn't say...

It isn't a good construct for a trigger but I was showing that you can call stored procs from triggers. To handle multiple inserts I could have while looped through...

You can most definitely call stored procedures from within triggers I have done it before.

You populate a number of variables from the inserted/deleted recordset and then call the proc in...

Cool. Its definitely an improvement your using CTEs instead of my temp tables and using

the new SQL 2005 functions which are good. I've never used the ntile function before and...

Sorry my computer spazzed out and somehow sent the message before I wanted it to.

I am trying to write a report of no importance apart from my own use and...

Yes your right in that at the moment dev isn't really dev but more stage 1 of a 2 stage process

in rolling out sites where each stage takes place on...