The syntax to execute a query on linked server without open query is:
LINKEDSERVERNAME.DATABASENAME.SCHEMANAME.TABLENAME
Also, you can execute stored procedures, tables, and functions from this approach.
Querying data from a Table/View:
select top 5 * from prod.db_customer.dbo.tbluser exec prod.db_customer.dbo.[select_recent_requests] '123'
Execute the above procedure, did it run successfully?
Yes then no problem! 🙂
But some times this error happens:
"Msg 7411, Level 16, State 1 Server is not configured for RPC".
To resolve this error go to Properties of your linked server.
Open Server Options.
RPC is used to allow remote procedures calls “from” the linked server.
RPC Out is used to allow remote procedure calls “to” the linked server.