I am creating a ## table and trying to access it from VB and .NET. I am succesfully able to do this from VB but in case of .NET its not accessible. Can anybody guide me about the problem and its solution.
A table created with the ##prefix is a global temporary table. When they are created they exist as long as there is at least one connection referencing it still open. As soon as all connections referencing it are closed the table is 'destroyed'.
My guess is that your .NET code is opening a connection, creating the global temp table and then closing. Next you open a connection again and try to reference the table, when it is of course no longer existing.