No, but actually, I just found the problem. Evidently SQL server does not re-check the key again once you run the query, unless you restart the services, or run dbcc freeproccache. Once I did that, SQL checked the key and all worked as expected. thanks for your input.
... I just noticed you are in SLC. You know, I have family out there and I been trying to find a SQL position out there for a while. No chance your company has an extra one open is there??
Thanks in any case.
>Are they a DBReader?
>
>>I am trying to use Ad Hoc Queries to load data from incoming Access files. I can make the procedure work with my login, but when I use another login that does not have sql sysadmin permissions, it says I do not have permissions to run that query. I have made sure the permission to run distributed queries is turned on both in SQL Server and in the registry. The test user does have owner permissions on the database with the procedure, tables, etc..
>>
>>Any help is greatly appreciated.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.