MVXJDTA.MITALO is just a regular table, no table-valued function;

I don' see what is wrong with the hint ?

@hints = N'OPTION (TABLE HINT ( MVXJDTA.MITALO, INDEX( MITALO10) , NOLOCK ))

Msg 8724, Niveau 16, État 1, Ligne 1

Cannot execute query. Table-valued or OPENROWSET function...

Thank you for your detail explanation.

I finally found out why it was not working, I was not specifyig the correct shema, instead it was created in master data base and...

Still cannot get this to work, any other ideas ?

Yes, the statement is strictly a copy/paste of original one; i tried several other one, adding blanks at the end, etc.., but no change.

This is not linked to being recognized...

This is the error message I receive :

Msg 102, Niveau 15, État 1, Ligne 1

Incorrect syntax near '@P0'.

Msg 10516, Niveau 16, État 1, Procédure sp_create_plan_guide, Ligne 20

Cannot create plan guide 'MITALO Jct' because @module_or_batch can not be compiled.

It refers...