Monday, December 6, 2010

SSMS Bug - Modifying UNIQUE Constraint

I got this unhelpful error message due to the fact my password expired and my login credentials were invalid.  Below is the detailed error message provided by clicking on the second button from the left on the bottom left of the window.

===================================

Unspecified error
 (MS Visual Database Tools)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.DataTools.Interop.IDTTableDesignerFactory.EditTable(Object dsRef, Object pServiceProvider)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.TableDesignerNode.CreateDesigner(IDTDocToolFactoryProvider factoryProvider, IVsDataConnection dataConnection)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con, String fileName)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.GetTableDesignerNode(Urn urn, IManagedConnection connection)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.ModifyTableCheckConstraint(Urn constraintUrn, IManagedConnection connection)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.InvokeDesigner(IManagedConnection connection)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.Invoke()