Viewing 2 posts - 1 through 2 (of 2 total)
you cannot use #temp table in the UDF that is created in the SP, because it is automatically dropped by the when SP ends.
Imran
April 28, 2004 at 6:06 am
#504478
you can use SP_OACreate, SP_OAMethod and other SP_OA sps to use ole objects in SPs just like in VB or VBS
April 28, 2004 at 5:56 am
#504476