You need the IP Address of the data modual, not the IP that it gives out to that particular box. You need too use the IP that the world sees,...

Herman

Thank you so very much for your time that you spent writing this.

I should have stated that I cannot use Dynamic SQL either. That is my fault totally.

No Loops, no...

Never, ever will I use a Cursor. But thanks for the info.

Andrew SQLDBA

I strongly agree with Jason, and stop using a Cursor.

They are only a curse on a database.

Andrew SQLDBA

Yes, absolutely

Create a stored procedure, and then use the Schedule to fire it off when ever you need. Create a SQL Job and then schedule that job. You can fire...

One the end of the line with the key, that is connected to the Primary Key, on the other end, in this one to many relationship, that is the oo...

Nothing at all, this is one of the Development boxes, I am the only person on that box. It has about 20 databases on it.

I know the question is very...

I believe that you should NEVER use a cursor of any type. There is always a better way.

Andrew SQLDBA

Thanks, I plan on doing just that in SSIS

I was just trying to figure out what may be causing the DTS issue. I was thinking if they had created a...

Exactly

I did not want to give advice until he was clear about what was needed. Some people do get the logs confused

Andrew SQLDBA

Have you tried SP_Who?

Are you referring to the Transaction Logs, or the SQL Event Logs?

Andrew SQLDBA

LMAO

Exactly Right. At least make a copy of the table first.

Andrew SQLDBA

What????

Have you read the SQL Books Online for the syntax for an UPDATE statement?

Can you give us an example of what the "registry" is?

Andrew SQLDBA

Great catch

I looked at that and did not even see the error.

I think that I will be going home now, it has been a very long week already

Andrew SQLDBA