Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Stored Procedure communication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-12-03 : 07:56:50
Bhanu writes "1.Can 2 stored procedures communicate with each other..means one stored procedure can call the other?
2. I am having one storedprocedure sp1 in pubs and one storedprocedure sp2 in Northwind then can how can i call sp2 from sp1?"

Andraax
Aged Yak Warrior

790 Posts

Posted - 2004-12-03 : 08:17:08
1. Yes they can
2. exec pubs..sp2 (or exec pubs.<user>.sp2 if not owned by dbo)
Go to Top of Page
   

- Advertisement -