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 success status

Author  Topic 

naveentnk
Starting Member

15 Posts

Posted - 2009-05-06 : 00:35:29
Hi Everybody,

Can any one help me in finding whether a stored procedure run successfully or not. I am using sql server 2000. I am calling a sp in another sp. Basing on the status of the innner sp i need to do some operations.

Thanks in advance






Who is wise? He that learns from everyone. Who is powerful? He that governs his passions. Who is rich? He that is content. Who is that? Nobody.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-06 : 01:43:37
declare @rc int

exec @rc = dbo.uspMyStoredProcedure

print @rc



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -