MS SQL and stored Procs

[eluser]Kamarg[/eluser]
When using temp tables in MSSQL you don't need a drop table statement as the table scope is limited to the session in which it is created and will be automatically dropped when the session ends. Not sure if that will solve your problem or not but it's worth a shot.