When I deployed the code, the linked server was not recognized (the name of my server is ServerName\Instance1.

It seems that the code does not work with named instance.

I set up a linked server names .\Instance1 and it worked (I added the parameter @sLinkedServer Varchar(80) to the stored procedure.