Sp_whoisactive leads to an unknown query: "Insert Into <table name >> select *, %% bmk %% from <table_name> (maxdop 1)"

Question

sp_whoisactive results in an unknown query:

 insert into <table_name> select *,%%bmk%% from <table_name> option (maxdop 1) 

I checked the above code block, but did not find this code in any of my procedures. Can anyone suggest what this request can do.

Answer 1

This clustered index is rebuilt.

% BMK% is a function that maps old bookmarks to a new one.

The document has a document describing the process: https://technet.microsoft.com/en-in/library/cc966402(en-us).aspx

Answer 2

sp_whoisactive is not a SQL Server built-in procedure.

This is UPD (Used Specific Procedure).

Check the procedures in your database or master / msdb