Disk is cheap. Let the db expand and don't worry about shrinking. thanks for your help guys.

Edited by - gajajojo on 12/19/2001 10:28:48 AM

Well after turning off the "Auto-Shrink" function on the database, I came in this morning and the users were working fine. No permossion lockout at all. Any ideas as to...

I ran a profiler last night. Last user signed off at 6:30 P.M. Backup happened at 10 and completed. No activity until 6:58 A.M. with the first user signing on....

The user's ability to SELECT and view anything leads me to believe it is not a lock. It's almost as if their INSERT, UPDATE, DELETE permissions have been revoked.

No special situations with the users. they are all members of public. Backup Exec shows nothing unusual and has been running nightly for months.