Not positive about this, but... I believe that I read somewhere you can't delete the user if it has objects assigned to it. IE Tables.
Make sure that all of the objects that this owner used to have are changed to have dbo (or sa) as the owner. Then you might be able to delete the user. Steve -----Original Message----- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 12:40 PM To: CF-Talk Subject: Drop User in SQL Server This may be better posted on a SQL board, but I know there are a lot of SQL Server gurus out there and I need your help! A client's web host just had to reinstall SQL Server 2000, and I am having a hard time getting a former user name to work properly, or setup a new user name. If I setup a new user name, the datasource appears to work fine in CF 5 admin. Then when I try a page I get a message: "ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'grpdes'." When I log into RDS in CF Studio the old user name shows up in the datasource; for example: "BandD.grpdes" ("BandD" is the old user name.) I've tried to delete the user name, but it will not remove itself from the "Public" role. If I try and recreate the user name I get the message: "Error 15023: User or role 'BandD' already exists in the current database." I've tried to detach the database, create the user (temporally attaching the user name to another database), re-attach the database and assign the user name to the database, but I get the "Error 15023 ..." Any ideas would be greatly appreciated! Thank you, Stan Winchester [EMAIL PROTECTED] http://www.aftershockweb.com/ Tel. 503-244-3440 Fax 503-244-3454 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
