Monday, March 19, 2012

Automatic query killing...

All,

Is there a way to have SQL server automatically kill a spid when its result set gets to be larger than a specific threshold( eg 3 gigs) ?

Any help is greatly appreciated: any sample stored procedures or code library for doing something like this?

Thanks,

IsaacThat's a scary post...

I'd invest more time determining IF a process would be one that resembled a run away train...

Imagine the rollback...

No comments:

Post a Comment