Andy,

I have been working with this problem this week. Amazing timing. We finished an application to a client a month ago, and she doesn't know SQL Server, but decided she could write reports to it anyway. She wrote some stored procedures and the other people in her office couldn't run them.

I diagnosed it as a ownership problem over the phone and was happy to hear I was right (it's so rare). I created and sent her a script that automatically changes all of her stored procedures to 'dbo'. Problem solved.

Patrick Birch

Edited by - pbirch on 10/17/2001 07:29:38 AM