SQL Server throws a wobbly when one tries to declare/create the same-named temporary table more than once in the same procedure - I guess the query analyser assumes that all temp table creations ...

For more information and restrictions on these and other SQL statements, see your SQL documentation. You can use the prompt facility to display a prompt window when non-SELECT SQL statements are ...