Correction to above post...

I had your issue, and managed a temp fix as below (at least it will work)....

In SSMS, browse to your linked server: ADSI.

Right-click ADSI, select properties, click...

.

Hi yes

In SMSS, on menu click tools, customize, click button keyboard.., under Environment, select Keyboard.

Assign code below to a shortcut e.g. CTRL + 4.

SELECT p.SPID, Blocked_By...

Ah additionally I have added fill factor, and a really cool addition- with ONLINE = ON for nonclustered indexes (so you don't lock the production table when adding the index).

Note:...

Hi

Thanks for the original query!

I modified it to have includes.

Additionally will create composite index columns in the correct sequence, I found that your original query worked well, however the sequence...