Adam, Thank you; running the stored procedure “sp_changeobjectowner” fixed the problem.
Thanks again, Stan Winchester [EMAIL PROTECTED] http://www.aftershockweb.com/ Tel. 503-244-3440 Fax 503-244-3454 >You will probably want to change the object owner for each table to the dbo >user. You do this using the sp_changeobjectowner stored procedure on each >table - either in query analyzer, or a script you've written. I've pasted >the books online entry for this - I have it book marked :) > >Adam. > … >Examples >This example changes the owner of the authors table to Corporate\GeorgeW. > >EXEC sp_changeobjectowner 'authors', 'Corporate\GeorgeW' > >> -----Original Message----- >> From: Stan Winchester [mailto:[EMAIL PROTECTED] >> Sent: Friday, June 13, 2003 11:40 AM >> 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
