if you've given a bunch of tasks and milestones to achieve within very limited amount of time and keep worrying what will happen until you have implemented a new system, there are things that can be done like triggers that will prevent oldies from shouting in one ear and bosses in the other one

I had the same thought (ughh - where to begin), I decided not to respond (several times) to that thread but after Peter took the plunge I decided to try and address the first few issues that came to mind. Holy cow what a mess!

I had the same thought (ughh - where to begin), I decided not to respond (several times) to that thread but after Peter took the plunge I decided to try and address the first few issues that came to mind. Holy cow what a mess!

Be One with the OptimizerTG

I was thinking of suggesting that he add the WITH RECOMPILE option to the stored procedure he is calling from the trigger, but I wasm't feeling quite evil enough.

I cook. Cookies, gumbo, jamblaya, steaks, pasta, pie. Just about anything. I just started smoking brisket and ribs actually.

Graz doesn't cook. First time I was at his house to cook something he (true story) didn't have a salt shaker. Asked him where the salt was...got a blank look. So when we have a get-together at his place, I bring everything: pots, pans, knives, ingredients, and everything. He provides beer. I think it's a fair trade, and so does he.