I am afraid I am a complete newbie to GIS and ArcGIS and it has fallen on my shoulders to try and resolve a problem with our ArcGIS installation. Assume I know nothing about GIS or the software please...until 2 weeks ago I hadn't even touched a GIS system. Anyway we have ArcCatalog 9.1 and ArcMap 9.1 installed on a very old server.
I can see the tables/views created in the database but the user's layers are not being populated (red exclamation marks in ArcMap).
I have opened up ArcCatalog and I can see the database connections on the server under Admin User's app data folders. If I open up these (there are a number) some or all have at least one of the tables missing or a necessary view missing.
I think the error is related to registering the tables with the sde.
Sorry for any mistakes I have made, I have spent a bit of time on this and will edit/correct the above as I receive further information.
EDIT (content removed above as I try and focus in on the true problem)
I have recreated the table the scripts are failing to create from a database backup. I can then see this in one of the database connections on ArcCatalog. However when I try and import the feature class into the other connections it comes up with an error stating:
Table Already registered.....violation of UNIQUE KEY constraint....
Obviously the table exists now but I cannot see anything within the DB Connections relating to the same name. I believe I need to unregister or re-register the table with the sde...or something?!
Edit - Full error when trying to "copy features":
Error in creating output c:\....... table already registered [Microsoft OLE DB Provider for SQL Server: Violatio of UNIQUE KEY constraint 'registry_uk2'. Cannot insert duplicate key inobject 'sde_table_registry'.] Failed to execute (Copy Features)."