>>To all,
>>
>>I'm running the ExecuteNonQuery method of a standard ADO.NET SQLCommand class. When I create a local table (CREATE TABLE #myTable ...) I get an error message "Invalid object name '#myTable'".
>>
>>It's not my syntax, I'm using code that's derived from code I developed to create and load a DB via Query Analyzer.
>>
>>I can create, populate and drop "regular" tables, but ADO.NET/SQL Server doesn't like the '#'.
>>
>>TIA,
>>Thom C.
>
>Thom,
>It works for me. Do you get the error when you create it? Or when you disconnect and connect again?
>Cetin
Here is a sample that worked:

using System;
using System.Data;
using System.Data.SqlClient;
class test
{
  static void Main(string[] args)
 {
       SqlConnection sConn = new SqlConnection 
      ("Data Source=(local);integrated Security=sspi;");
       string strCreate = 
@"CREATE TABLE #myTemp (myVal varchar(10))
INSERT INTO #myTemp VALUES ('hello')
INSERT INTO #myTemp VALUES ('there')
INSERT INTO #myTemp VALUES ('again')";

       string strQuery = "SELECT * FROM #myTemp where myVal like '%e%'";
       
       SqlCommand cmd = new SqlCommand(strCreate, sConn);
       sConn.Open();
       cmd.ExecuteNonQuery();

       SqlCommand cmdQ = new SqlCommand(strQuery, sConn);
       SqlDataReader rdr = cmdQ.ExecuteReader();
       while (rdr.Read())
       {
        Console.WriteLine(rdr.GetString(0));
       }
       rdr.Close();
       sConn.Close();
 }
}

Cetin