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

Article translations Article translations
Article ID: 970575 - View products that this article applies to.
Expand all | Collapse all

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: July 16, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Visual Studio Team System 2008 Database Edition
Keywords: 
kbprb kbsurveynew kbqfe kbexpertiseadvanced KB970575

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com