I would like to add folders to my MSSQL server data source. I can connect to the server using windows integrated security or SQL user name and password. I have db owner user role for the SQL database. While viewing the contents of the MSSQL Server data source in the MF project pane, I see a System Data folder. I would like to create additional folders within the data source to organize the various data layers I will use in my Manifold projects. When I attempt to create a new folder I receive the following error message: Violation of PRIMARY KEY constraint 'OBJ_PROP_X'. Cannot insert duplicate key in object 'dbo.mfd.meta' The duplicate key value is (dbo.mfd_root, Path.1.Value). The statement has been terminated. My search on the web seems to indicate an SQL Server error; that I'm trying to add a duplicate key to an existing table. How can I overcome this error?
|