And again "object reference not set..." (loading a project)

I see there are a couple posts from people dealing with an "object reference not set" error. I'm getting the same error, but in a different circumstance. I...

  1. created a new SQL Server 2000 database project
  2. imported schema from a SQL Server 2000 database
  3. closed and saved the project
  4. re-opened the project

The error occurred during the project load.

I'm wondering if it might have something to do with the large number of objects in the schema (400+ tables, 3000+ procedures/functions). After opening the project, Visual Studio "thought" for a while before throwing the error. I tried a much smaller db, same scenario, no issues.

I just tried the same scenario, this time starting with a SQL Server 2005 project and using a SQL Server 2005 db as the source schema (the schema was basically identical to the first, however). I get the same error on re-open of the project.

Regards,

Daniel

[997 byte] By [DanielPratt] at [2008-2-6]
# 1
Were there any other errors in the error window?
RichardWaymire-MSFT at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 2

Hi Richard,

Thanks for following up. Prior to closing the project, yes, there were a number of database consistency errors listed. None of them appeared to be valid, btw. After trying to open the project again and getting the error, no, the error window was empty. I did notice this bit in the output window:

Output window created.
Entering constructor for: Microsoft.VisualStudio.TeamSystem.Data.Common.UI.VSPackage
Entering Initialize() of: Microsoft.VisualStudio.TeamSystem.Data.Common.UI.VSPackage
Entering Microsoft.VisualStudio.TeamSystem.Data.SchemaAndDataCompare.UI.Editors.DataCompareEditorFactory constructor

Thanks,

Daniel

DanielPratt at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 3
This seems very odd. My first step would be to uninstall TS Data and then re-install the CTP after a reboot.
RichardWaymire-MSFT at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...

Visual Studio Team System

Site Classified