Calling a stored procedure from another SQL Server Database Engine

Question

From SQL Server Management Studio I have connected to an SQL Server database engine. This database engine has a lot of databases. From a store procedure defined in a database I am trying to call a store procedure in another database that it is in another SQL Server database engine. So I have done:

exec [MyDatabaseEngine].[MyDatabase].[MyStoreProcedure] param1, param2

But it is not working.

I do not know if I have explained it correctly. If not, please let me know.

@SeanLange arrgggggg, yes... you are right! thx very much! Post the answer and I will vote you. — Willy
– Willy, Commented Jun 7, 2017 at 16:02

Sean Lange · Accepted Answer · 2017-06-07 16:12:45Z

3

You are missing the schema. The format is [LinkServer].[Database].[Schema].[Object]

answered Jun 7, 2017 at 16:12

Sean Lange

33.7k3 gold badges28 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Raghu Ariga · Accepted Answer · 2017-06-07 16:19:19Z

2

You need to have linked server created with credentials access to the other database. More info

https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine

Once you have it, you can run queries on another server

SELECT name FROM [SRVR002\ACCTG].master.sys.databases ;  
GO

answered Jun 7, 2017 at 16:19

Raghu Ariga

1,1391 gold badge19 silver badges28 bronze badges

Collectives™ on Stack Overflow

Calling a stored procedure from another SQL Server Database Engine

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related