How can we help you today? How can we help you today?

BLOCKING PROCESS ALERT Exclude queries that contain objects...

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?
PatrickW
0

Comments

5 comments

Sort by
  • 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
    0
  • 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:

    4yb5u4y422ku.png
    Russell D
    0
  • 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
    PatrickW
    0
  • 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!
    Russell D
    0
  • 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
    PatrickW
    0

Add comment

Please sign in to leave a comment.