15 seconds - on Big Blue maybe, but not on my laptop, where it ran like an arthritic dog!  Got bored and killed it before it finished!!  Thanks Jeff!

Try running

exec sp_who2

from Query Analyser and see whether the information displayed there identifies your users.

So you do not want to track the fact that a record (or records) have been...

The question does not state whether or not the GUID is a clustered PK - I therefore assumed it was not.

Triggers sound like the way to go - I'm assuming that you're thinking of creating two or three tables along the lines of:

AuditInsertDelete(AuditInsertID, Date, Action, Table, user, field1, field2, etc)

AuditUpdate(AudotUpdateID, date, table,...

Good.  You two have already had the discussion that I was about to get into!

Why did you need to use a cursor?  Perhaps we can find a (fast) set-based approach if you provide more info.

Me too!  Good idea.

Perhaps you could add an extra field to the table you are inserting into - call it BatchID or something similar - then you just need to work out how...

Have you tried running in debug to try and isolate exactly when the error appears?

As you can see from Chris' example, the subquery cannot execute without the parent query - this is what 'corelated' refers to.

An independent subquery can run in isolation, eg

select *...

How are you loading the data at the moment?

1.5GB every two hours is lots less than 150GB a day - I don't understand!

Does the data need to be available to...

Please do not submit the same post in multiple forums - follow this link to see my suggested approach, which expands a little on Andy's.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=225706

This is fairly straightforward.  You do not need separate databases for this information, even if the number of schools gets very large - you will find that having everything in...

Please do not submit the same post in multiple forums.

Use this link for answers to this question:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=225720

This isn't very elegant but it works.  You'll notice that the calculation of @totalmins at the end relies on integer division - related to the MOD function that you are...