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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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


<ianforgroupuse@xxxxxxxxxxxxx> wrote in message
news:1175263489.077775.31140@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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?



.

Relevant Pages

  • Re: Using temp tables
    ... you can store the data in Temporary tables or Physical ... The source for information on temp tables is - BOL- Books online is the best ... should be same as output of stored procedure. ... The difference is local temp tables are visible only to the execution. ...
    (microsoft.public.sqlserver.programming)
  • Re: Temporary results used by SP
    ... You can create the temp table prior to the execution of the stored procedure and have the sp insert ... > b) use the data in "xyz" to do something ...
    (microsoft.public.sqlserver.programming)
  • Re: Indented Bill of Materials
    ... have no parent are inserted in a temp table, ... execution of the WHILE statement, the last executed statement is the SET ... In the first iteration, @lev will be increased to 1. ...
    (microsoft.public.sqlserver.programming)
  • Re: Performance enhancement
    ... speed up execution? ... > sybase, but it should be similar to other DBMS for this to work. ... > say that the adoDataSet is opening a temp table, ...
    (borland.public.delphi.database.ado)
  • Re: Indented Bill of Materials
    ... but eventually I will be calling SQL ... > have no parent are inserted in a temp table, ... > execution of the WHILE statement, the last executed statement is the SET ... > In the first iteration, @lev will be increased to 1. ...
    (microsoft.public.sqlserver.programming)