sql server msde: SQL server 2005 Express - Vista - Invalid object name '#spdbdesc' -- sql server msde

SQL server 2005 Express - Vista - Invalid object name '#spdbdesc'

ianforgroupuse NO[at]SPAM hotmail.co.uk
3/30/2007 7:04:49 AM

sql server msde:

I'm running Vista Business edition on 2005 Virtual PC.
Installed SQL Server 2005 Express latest download, with instance of
MSSQLSERVER and service accounts running under "NT AUTHORITY\SYSTEM".
Mixed mode authentication specified and sa password specified.
Used server manager to create user login with sysadmin role.
Login using windows authentication.

Run my application and database is created and populated with default
records.

However, my application executes the stored procedure "sp_helpdb"
which fails with "Invalid object name '#spdbdesc'" error.

If I run a query in server manager to execute same procedure logged in
as the same person it runs ok and returns a table of information.

All this was working ok on XP with MSDE2000A previously.

I'm programming in .NET C# CLR2.0, any body know what's going wrong?

Re: SQL server 2005 Express - Vista - Invalid object name '#spdbdesc'

Aaron Kempf
5/1/2007 11:44:52 AM

a) ADO.net tries to close connections automagically for you
b) #tableName refers to a temp table-- does it exist when you're doing this?
c) temp tables that are created inside of a sproc are deleted at the end of
the sproc execution automagically

[quoted text, click to view]