Sorry, yes I did check for triggers and there aren't any (not visible to my login anyway - I'll ask a server admin to check for me).

The stored procedure really is in the same database as the tables; most of our stored procedures use the 3-part name because some operate across more than one database and...

The table(s) and stored procedure are definitely in the same database and that is the same database specified by the application when it opens the connection. We've tried explicitly granting...

Thanks for your response. The error we're getting is shown in the attachment; not much detail as it's being displayed by an old VB6 program. The stored procedure just does...

No, it's a member of the db_datareader role and the only other permission is the Execute on dbo.

This works with the data provided.

Selectdistinct

a.EmplID,

Case when c.EmpID is null then b.Designation else c.Designations End as [Role]

from #EmpIDs a

inner join #EmpRoles b on a.EmplID = b.EmpID

left outer join #LatestRoles c...

My 2 penn'orth; I think the error you're getting is from an attempt to execute the stored proc with a connection that isn't open so you're not seeing the message...

We need to copy some columns for new and amended clients from an in-house database to a 3rd-party one. The original process involved copying the data to an intermediate database...

I would try;

select distinct top 100

i.invoice_id, i.buyer_code, i.submit_time, i.request_id

from

dbo.invoice i

inner join dbo.invoice_adj ia on i.invoice_id = ia.invoice_id and ia.amount !=0

left outer join dbo.invoice_detail iad on i.invoice_id = iad.invoice_id

left...