FIX: The Visual Studio IDE crashes when you add a permission and set the Object Name property to an empty string to the Database.sqlpermissions file in a Microsoft SQL Server database project in Visual Studio Team System 2008 Database Edition GDR

This article has been archived. It is offered "as is" and will no longer be updated.
Symptoms
You create a Microsoft SQL Server database project in Microsoft Visual Studio Team System 2008 GDR. You add a permission and set the Object Name property to an empty string to the Database.sqlpermissions file. When you save the file, a Critical Error Encountered dialog that contains the following information pops up:
The general distribution release (GDR) for Visual Studio Team System 2008 Database Edition has encountered an critical error and must exit. Do you want to try to save your solution and any open documents before exiting?
Object reference not set to an instance of an object.
   at Microsoft.Data.Schema.Sql.SchemaModel.SqlServer.PermissionStatementTypeComparer.GetHashCode(PermissionStatementType obj)   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)   at Microsoft.Data.Schema.Sql.SchemaModel.SqlServer.SqlXmlPermissionsModelBuilder.GroupPermissionElements(IList`1 permissions, PermissionStatementTypeComparerFlags comparerFlags)   at Microsoft.Data.Schema.Sql.SchemaModel.SqlServer.SqlXmlPermissionsModelBuilder.ValidateForDuplicatePermissionElements(SqlPermissions sqlPermissions, PermissionStatementTypeComparerFlags comparerFlags)   at Microsoft.Data.Schema.Sql.SchemaModel.SqlServer.SqlXmlPermissionsModelBuilder.ValidateXmlPermissions(SqlPermissions sqlPermissions, IList`1& errors)   at Microsoft.Data.Schema.Sql.SchemaModel.SqlServer.SqlModelBuilder.AddXmlPermissions(CustomSchemaData customData)   at Microsoft.Data.Schema.Sql.SchemaModel.SqlServer.SqlModelBuilder.Add(CustomSchemaData customSchemaData)   at Microsoft.Data.Schema.SchemaModel.FileManager.AddOrUpdate(CustomSchemaData customSchemaData)   at Microsoft.Data.Schema.Build.DatabaseTaskHost.AddOrUpdate(CustomSchemaData customSchemaData)   at Microsoft.Data.Schema.Sql.Build.SqlTaskHost.AddPermissionsFiles(IList`1 permissionsFiles)   at Microsoft.Data.Schema.Sql.Build.SqlTaskHost.OnProcessFileListPriorToBatchLoadOrUpdate(IList`1 allFiles)   at Microsoft.Data.Schema.Build.DatabaseTaskHost.Add(IList`1 sourceItems, LoggingBehavior loggingBehavior)   at Microsoft.VisualStudio.Data.Schema.Project.Project.Features.FileManagerFeature.ProcessFilesInQueue(ProjectSyncOption projectSyncOption, Boolean ignoreQueueStabilization)   at Microsoft.VisualStudio.Data.Schema.Project.Project.Features.FileManagerFeature.OnIdle()   at Microsoft.VisualStudio.Data.Schema.Project.Project.DatabaseProjectNode.OnIdle()   at Microsoft.VisualStudio.Data.Schema.Project.Project.DBProjectIdleProcessingComponent.FDoIdle(UInt32 grfidlef)
Then, the Visual Studio IDE crashes.
Resolution
To resolve this problem, upgrade to Microsoft Visual Studio Team System 2008 Database Edition GDR R2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
970479 List of fixed issues in the Microsoft Visual Studio Team System 2008 Database Edition GDR R2

Note Microsoft Visual Studio Team System 2008 Database Edition GDR R2 replaces Microsoft Visual Studio Team System 2008 Database Edition GDR.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Properties

Article ID: 970575 - Last Review: 01/16/2015 04:32:00 - Revision: 2.0

  • Microsoft Visual Studio Team System 2008 Database Edition
  • kbnosurvey kbarchive kbprb kbsurveynew kbqfe kbexpertiseadvanced KB970575
Feedback