How to access the Stored Procedure in Other Server

Question

Hi Guys, Is it Possible To access the Stored Procedure from the other Server Sql Server to another Sql Server For Example Consider Stored Procedure Name : USP_GetResults which is the Sql Server ip name 192.168.1.98 can we access this procedure to another Sql Server ip name 192.168.1.103

Hariharan Krishnamoorthi · Answer

Please try the below, EXEC [servername].[dbname].dbo.[StoredProcedure] Also please refer linked server concept in SQL. Sample: http://www.c-sharpcorner.com/UploadFile/suthish_nair/linked-servers-in-sql-server-2008/

Manish Kumar · Answer

Another possible approach is make a linked server between 2 servers and call your sp like in below format. exec [ 192.168.1.103 ].[dbname].dbo.[your sp name] with parameters. Here 192.168.1.103 is linked server name. Check below link for making linked server https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine

Catcher Wong · Answer

Hi , Of course you can do that !! You can use the Opendatasource to do that thing! Here is an easy example : EXEC OPENDATASOURCE( 'SQLNCLI' , 'Data Source=192.168.1.98;Integrated Security=SSPI' ) .YourDatabase.YourSP And for more details , you can follow the below link: https://docs.microsoft.com/en-us/sql/t-sql/functions/opendatasource-transact-sql Hope this can help you!

Ramesh Barik · Answer

If you have access permission to the database ( 192.168.1.103 ) then you can.