Standard Edition

10.0.4000.0

SP2

There are no DML triggers. I have scripted out everything as well as checking the included objects, in multiple ways.

I cannot figure this out. I...

opc.three, first, thanks for pointing out the USE statement. I simply missed that. Second, I just re-checked and the procedure is correct.

I'll admit, in all my testing, I...

When I said we were going ahead with the idea that the backup on the 26th and the diff on the 5th would be good, I meant that was the...

Thanks Dev and Steve. I am going forward with the idea that the full from the 26th and the diff from the 3rd are intact. I am also...

History tells me this is not going to happen with this system. That doesn't mean I won't try, though.

Anyway, I realize an index is the best remedy for poor...

I would love to add an index but this is a third-party database so it's not going to happen - at least not by me. The vendor would have...

Caching sounds plausible but both these databases have been out there for at least a week and during that time both the server and my machine have been restarted. ...

As usual, I found the answer just a few minutes after submitting this.

The change is with the metadata permissions and how those come into play when querying the catalog views....

I am just getting back from the holidays and getting caught up.

I did get my problem resolved and it was with using the sp_browsereplcmds procedure. I had been having...

No, this is transactional replication.

Restarting wouldn't help because these are legitimate errors in the data. Most of the time, there are one or two scenarios where associated data can...

Here some more info that may, hopefully, help better explain what I am looking for.

When I get a replication error, I see something like:

The INSERT failed because the "customer" does...

Here some more info that may, hopefully, help better explain what I am looking for.

When I get a replication error, I see something like:

The INSERT failed because the "customer" does...

Just an update. The problem was a typo in the SPN setup. There was a small piece missing in the domain qualifier.

I looked at it a million times...

What do you mean by "1.I Hope your user is not a member in windows group"?

Thanks Steve but, yes, I have logged in as the service account and the command line works fine. The file is also not in use.