Hai,

   I found onething.  If i make new connection then the table created.  then i tried to create a table it is not created but no error message is giving.

 ...

Hai,

  You are right. a new table created on each run.  We are using the global connection for whole module.  It will closed once the application terminated.

Vijay

Hai,

 I am creating the tables in tempdb using ##. I am taking the @@SPID and adding to the name of the table before creating.  When run the report it will...