Hi everyone,

I posted a response and just checked and the response is not posted for some reason.

He is using Windows login. The SP has two insert statements, one is to database X on server 1 and other is to database Y on server 2. The insert to database X succeeds, and the other fails. Also, JFYI, database Y is replicated from database X (on a nightly basis) using an EMC software. Once the database replication is over, I run a script that grants database access and permissions to all users. Not sure if this has anythig to do with the problem though.

The SP is owned by dbo. I think that the SP is not run under dbo entirely. I just created a table and a SP that inserts data into that table. I gave execute permissions to my user and another user and had both of them execute the SP. The one that is having problems with the other SP had the same error while the other person did not have a problem.

Thanks again for your help everyone.