Creating SQL Blocks?

[Justin Cooke]

Hi All, We use MOM (Microsoft Operations Manager) software to monitor our systems. One problem it alerts us to is SQL blocks. However, it's too noisy and I need to tweak the alert rule. To make my testing easier, I'd like to be able to simply start and stop SQL blocking at my command (rather than wait for usage blocks to occur). I'm not a SQL expert (by any stretch :)) and I've been looking for a script I could run (maybe in two QueryAnalyzer windows) to force a SQL block to begin. I could then KILL the SPID when I was done testing. Do any of you know of something like this? Is this so easy, no one would ever post it on the web :). If so, please let me know how I should go about this. If it's possible to create blocks without altering data, that'd be best. Thanks! Justin