sp_whoisactive resulting an unknown query: "Insert Into <table_name> select *,%%bmk%% from <table_name> option (maxdop 1)"

Question

sp_whoisactive resulting an unknown query:

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

I have checked the above code block but did not find this code in any of my procedures. Can anyone please suggest what this query might be doing.

Answer 1

This is a clustered index being rebuilt.

%BMK% is the function that maps the old bookmarks to the new.

There is a document here that discusses the process: https://technet.microsoft.com/en-in/library/cc966402(en-us).aspx