Russ, Have you looked into the sysusers or sysobjects tables for devildb to see if user/object bob12 is listed?
Did you assign a default database to the user when you created the user? Whenever I get any issues with SQL Users I remove them manually from the sys tables are add them in again. Gene -----Original Message----- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 11:27 To: [EMAIL PROTECTED] Subject: [ cf-dev ] SQL Server user corruption I have one particular database on our server that is causing me problems, lets call it "devildb" other people when logging into their own databases keep getitng errors relating to this one. E.G. user bob12 is not a valid database user in database 'devildb' No bob12 is not a user in that db, nor is he meant to be, nor is he connecting to that db or doing anything with it anyway. Anyone ever had this issue or aware of a nice easy fix. I have made a new copy of the offending database and imported everything form the old one and created a new user, but that didn't help. Russ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
