Home Forums SQL Server 2005 Development Access to temp tables across stored procedures RE: Access to temp tables across stored procedures
Christopher DeMeyer
SSC Enthusiast
Points: 131
More actions
April 29, 2004 at 6:52 am
#504655
The temp table #TmpA is out of scope for the sproc sp2.
You can either create the temp table in sp1 as ##TmpA making it global, or call sp2 from within sp1 so that it remains in scope.