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.