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. sp_changeobjectowner Changes the owner of an object in the current database. Syntax sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner' Arguments [EMAIL PROTECTED] =] 'object' Is the name of an existing table, view, or stored procedure in the current database. object is nvarchar(517), with no default. object can be qualified with the existing object owner, in the form existing_owner.object. [EMAIL PROTECTED] =] 'owner' Is the name of the security account that will be the new owner of the object. owner is sysname, with no default. owner must be a valid MicrosoftR SQL ServerT user or role, or Microsoft Windows NTR user or group in the current database. When specifying Windows NT users or groups, specify the name the Windows NT user or group is known by in the database (added using sp_grantdbaccess). Return Code Values 0 (success) or 1 (failure) Remarks The owner of an object (or the members of the group or role owning the object) has special permissions for the object. Object owners can execute any of the Transact-SQL statements related to the object (for example, INSERT, UPDATE, DELETE, SELECT, or EXECUTE) and can also manage the permissions for the object. Use sp_changeobjectowner to change the owner of an object if the security account that owns the object has to be dropped but the object must be retained. This procedure removes all existing permissions from the object. You will need to reapply any permissions you want to keep after running sp_changeobjectowner. For this reason, it is recommended that you script out existing permissions before running sp_changeobjectowner. Once ownership of the object has been changed, you may use the script to reapply permissions. You will need to modify the object owner in the permissions script before running. For more information about database scripting, see Documenting and Scripting Databases. Use sp_changedbowner to change the owner of a database. Permissions Only members of sysadmin fixed server role, the db_owner fixed database role, or a member of both the db_ddladmin and db_securityadmin fixed database roles can execute sp_changeobjectowner. 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! > > 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
