September 19, 2006 at 4:26 am
Hi good day, I just want to know about the remote stored procedure. How are we going to call a procedure to another server like for example: server A has a sample.dbo it contains sp_xxx_xxx and I'm in the server B has a sample2.dbo it contains script and want to call sp in the server A. Is there a way around here? I have already tried: SQLSERVER1.pubs.dbo.checkcontract but it didnt work out.
September 19, 2006 at 5:17 am
If the server is a linked server then SQLServer1.pubs.dbo.checkcontract should have worked.
You do have to tell SQL Server to create a linked server with the appropriate credentials though.
September 25, 2006 at 3:53 am
okay, thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply