UNCLASSIFIED Do you mean "Change Owner"?
Log on to the SQL database server Click Start > All Programs > Microsoft SQL Server > Enterprise Manager Expand to view the users of the ARSystem database Is ARAdmin the 'dbo' of ARSystem? If not, open SQL Query Analyzer from the Tools menu The following SQL statement must be run from the ARSystem database. Careful - The drop-down menu on the Tool bar displays which database will run the query. Type this SQL statement: sp_changedbowner ARAdmin, true Click the "Execute Query" icon or F5 on your keyboard. Exit SQL Query Analyzer. On exit, you will be prompted to save the query. Saving is optional. Note: ARAdmin cannot already be a user in the ARSystem database to become 'dbo'. ARAdmin must exist to become 'dbo'. The default password for ARAdmin is AR#Admin# Sandra Hennigan OSD Remedy Administrator Office # 703-602-2525 x251 CACI - Ever Vigilant(tm) Apparently, there is nothing that cannot happen today. Mark Twain -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bob Wallace Sent: Wednesday, February 28, 2007 9:35 AM To: [email protected] Subject: Dev server DB from backup of PROD - UPDATES required SQL Server I know that this has been asked and answered but I can not find it in the archives nor can a find a copy which I kept. I apologize, in advance, for asking again. Would someone please forward the series of UPDATE statements which are required when a backup of the production database is used to refresh the database on a dev server. Or a better search key word to identify the post in the archives; I tried "COPY" and "UPDATE DBO.", as well as a visual scan. We are using ARS 6.3, with HD 6.0, running on W2K3 server accessing SQL Server 2000. Thank you, Bob Wallace ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
