If a process is too cumbersome, then maybe you could be proactive...and go to HR...once a month (or just before your next audit visit???)...and ask for all 'leavers since dateX'. ...

"ummm.. are you really going to give away that kind of power to HR..?"..Totally agree.

Why not get yourself/admin put in part of the workflow process that deals with employees leaving...so...

forgive me if I'm on the wrong tack here.  but with windows authentication, there is no inputting of the password into SQL....so there is no failed SQL logon (for password...

Have a look at maintenance plans.....there is an option there to schedule backups, optimisations, etc multiple times a day...ie every 4-5-6 hours etc.

B.T.W....backup's every 4 hours will produce 6 backups a...

Yes....by thinking outside the box and running with a solution whereby "you monitor under intense supervision" from your production support team.  SOX doesn't say "Developers can't have ANY access to...

By my reading......if you have 1200 SP's and only 50 tables.....50 triggers might be a smaller task that would solve the same objective, than amending 1200 SP's.

I remember seening elsewhere (sqlteam.com) that there is a 'special' difference between COUNT(*) and COUNT(tblI.Img_ID)...difference relates to something to do with counting/summing NULLS.

Maybe the former is more suitable for you?

Do you need...

"I find it hard to believe that sql server 2k does not store a last run timestamp somewhere."

Don't be.....

a) Microsoft software!

b) High activity systems would spend more time logging their actions...

Connection reuse SHOULD/COULD only come into play, when a connection is closed (if's it in use, it can't be borrowed by someone else)

If all that is being done is conections...

I'm loath to say WRONG...but I think it applies here....given that there is no "last update date" column in sysobjects (in SQL2K anyway).  There is a refdate column, but I just...

Can you take out some of the 'funny sh*t' and see the effect of each portion on the overall affair?

ie....build it up from a small query and see which straw...

looks better.

what's the change in performance?

remember to flush buffers/cache  to get a proper performance benchmark.

I'd query your need to 'cluster' the tblimage on imageid....unless it adds some benefit to another part of your application.  There may be a better candidate for a clustered index....IF...

mmm...interesting approach.

can you put the calculation into a derived column...which may be indexed?

you may have to run an update statement to evaluate every row w.r.t the 'a,b,c,d,e' tests and then...

Which bit of the statement "Please contact the person in the post above if you are interested." (....either the specific words used or purpose behind the post) do some...