You are here: SQL server 2005 Express - Vista - Invalid object name '#spdbdesc' « MsSQL Server « IT news, forums, messages
SQL server 2005 Express - Vista - Invalid object name '#spdbdesc'

Posted by ianforgroupuse on 04/02/07 12:10

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?

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация