Capture return value from stored proc

From: mcnews (mcourter_at_mindspring.com)
Date: 04/08/04 

Date: 8 Apr 2004 04:32:13 -0700

how do i capture the return valuer from this SP?

alter procedure dbo.TableExists
@tablename as varchar(50)
as
if exists (select * from dbo.sysobjects where id = object_id(@tablename) and
OBJECTPROPERTY(id,'IsUserTable') = 1)
        begin
                return -1
        end
else
        begin
                return 0
        end

thanks much,
mcnews

Relevant Pages