I'm gonna let you have this one...

So any proof Heather about that statement?

It's a nice trick but it's the slowest of 'em all. The best is still the split function.

It's the same reason I'm always here... Learn something new everyday.

What exactly r u trying to accomplish in this stored proc?... I didn't see any reason to validate the use of a cursor in this case.

Can you post the whole...

can you post the code from all the sps so i can provide a better solution?

add a parameter to the 2nd sp

(Select SERVERID, MAX(UPDATED) as UPDATED, Drive from dbo.YourTable

GROUP BY

SERVERID, DRIVE) Y2

is a derived table, I basically select the last update date for each serverid/drive combinaison. Then I join...

Glad you could work it out.

I guess I didn't make myself clear. I would change the 2nd sp so that it doesn't work on only 1 row at the time, but on all rows...

Well then I would suggest to do as I proposed, but I would choose to have a job run every minute or so (however often you need). This job...

My previous query cannot work... this one is tested and does what you ask :

Select Y2.SERVERID, Y2.UPDATED, Y2.Drive, Y1.FreeSpace from dbo.YourTable Y1 inner join

(Select SERVERID, MAX(UPDATED) as UPDATED, Drive...

never did this but maybe something like that could do it

Select SERVERID, UPDATED, Drive, FREESPACE from dbo.YourTable

GROUP BY

SERVERID, DRIVE, FREESPACE

HAVING UPDATED = MAX(UPDATED)

It is considered a worst practice to call external process from within a trigger.

One thing you could do is create a table with 1 row and a few columns. ...

Run this in query analyser, then paste the results on this query in QA and run the statements.

Select 'UPDATE [' + user_name(O.uid) + '].[' + O.Name + '] SET timekeeper...

One thing I forgot to mention is that maybe the tempdb needs to grow to accomodate for this huge transaction. Maybe somebody else can confirm this.