>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