Martin,
>>Although .NET allows for debugging of Stored Procedures... I still use the Query Analyzer as I fill more comfortable using it... I guess I just need to explore this feature of .NET some more.<Don't feel bad ... I've been using .NET for 3 years and I still use Query Analyzer for testing out Stored Procs. ;-)
~~Bonnie
>Hi all! Just would like to share with you my experiences with Tmp tables. If I create them in a stored procedure and execute that sp using the EXEC statement (either from VB or Query Analyzer) the Tmp tables are automatically drop as soon as the SP ends execution... even if the connection is still open.
>
>However, when debugging the SP in the Query Analyzer... there is a need to explicitly drop the tables (Tmp tables ofcourse) even if the SP has ended it's execution... this is probably because the session has not ended.
>
>Although .NET allows for debugging of Stored Procedures... I still use the Query Analyzer as I fill more comfortable using it... I guess I just need to explore this feature of .NET some more.
>
>Regards to all!
>
>Martin