IMHO I have a job and unless I am willing to bite the hand that feeds me and am willing to be OUT OF WORK I would not do it...

If...

research BOL "detaching database from server" or sp_detach_db.

You may also want to make sure that the "active" part of EM is at the database level of the database you wish...

I would research and ensure that the NON-CLUSTERED index is not referenced in any code and then REMOVE it.

This way the system will start using the PK again.  OR you...

I would research the possibility of having the other SQL server start a job on your SQL server.

The problem as I see it is you don't know WHEN the NT...

hmmm,

Don't really know which is "better". 

If there is a valid reason for entering information for the same customers in 2 different systems that may have conflicting data then:

I would...

That should be a simple trace of the code that performs the :

• Insert/Update/Delete
• Check that table(s) for triggers that may fire
• Check to see if there are any jobs that look for...

Why not have the NT batch job start a SQL server JOB that you can interrogate and have that start another job OR

have the NT job kick the sp_start_job that...

Can you please post the revised code that you have removed parts from so we can see where the syntax error is coming from?

I have personally never used the rebuildm tool.  I have always done things the "hard" way 🙁 sorry

Well,

If you can't recover Master I think you are going to lose all your user information However, I think you can fix that without too much trouble.

1st copy the...

I think you are trying to make it harder than it is.  Basically I am assuming that you have a user-initiated DTS package or a scheduled package.  From there you...

You know WHEN the package was ran (or button pushed) and you have the DateTime items were created in the particular table(s) you are interested in so:

SELECT [Field list here]

 ...

Have you verified that the user that starts the DEFAULT instance is still active and is spelled correctly?

You could place the field data into a variable and then EXEC sp_executesql @field but....

IF there is no validation except to INSERT into the field WHY would there be code...

IF the SQLDBREG.EXE is installed on your ICH402W1 machine and you have already attempted the REGSVR32.exe option have you (I know I know MS answer coming) tried UNINSTALLING and RE-INSTALLING...