I wrote a stored procedure which uses temp tables in its logic, tested it in
query analyser it is executed without errors, when i try to execute it in
DTS activex script, it is failing. If i remove temp tables usage inside
procedure i am able to execute in the same activex script, can someone get
me more insight of it. is it really a problem ?, if it is how to avoid it.

Thanks,
Subbu.

What do you mean by 'failing'? Are you getting any errors? Do you have SET
NOCOUNT ON at the begining of your stored procedure?
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/


"Subbaiahd" <subbaiahd (AT) hotmail (DOT) com> wrote

You say it fails but give no error messages.

Also what is the code you are using?
What do you expect to happen?


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org