I knew this method is working for both SELECT on table and stored procedure, but I want to avoid this method because we don't want to use query in string...

Hello,

The default database of the user used to login of the linked server is the same than the database specified in the catalog property of my Linked server.

My question...

Hello,

I know that specifying the database name will work for both (SELECT and SP), but I need to don't specify it because we don't know the database name in our...