BLOCKING PROCESS ALERT Exclude queries that contain objects...

PatrickW

Exclude queries that contain SQL commands or objects matching the following regular expressions:

I've tried to put in
insert % select * from % option (maxdop 1)
- which is my index rebuilds but it didn't work - can we have some examples?

Russell D

You need to escape special characters in regex.

Eg

insert % select \* from % option \(maxdop 1\)

matches the query you've written above.

Russell D

Just to expand upon this, the inline help does contain more information, if you click the question mark next to the regex editor:

PatrickW

thanks, your 1st answer helped a lot, I didn't fully understand the "special characters need to be escaped" bit in the online help - but I do now - thanks

Russell D

No problem - if you think we can make the documentation better please let us know how. After all its only useful if people can understand it!

PatrickW

I think an e.g. in the online help would help,
so, insert into select * from xxx, would become ...etc
thanks again. Happy New Year