James, I believe you forgot an underscore "_" between db and chaining.
Try this: OSql -E exec sp_dboption 'RealSecureDB', 'db_chaining', 'true' <cr> Bob Murray -----Original Message----- From: [EMAIL PROTECTED] On Behalf Of Mohr James Sent: Thursday, January 15, 2004 7:01 AM To: [EMAIL PROTECTED] Subject: [ISSForum] Still cannot enable DB Chainging Hi All! Well, my boss decided to install a full version of MS SQL Server 2000 on the machine, which I just did. In order to upgrade our application, we need to enable db chaining. In the Microsoft knowledge base there are two ways to do this: exec sp_dboption 'RealSecureDB', 'db chaining', 'true' This returns: Database option 'db chaining' does not exist. Settable database options: ----------------------------------- ANSI null default ANSI nulls ANSI padding ANSI warnings arithabort auto create statistics auto update statistics autoclose autoshrink concat null yields null cursor close on commit dbo use only default to local cursor merge publish numeric roundabort offline published quoted identifier read only recursive triggers select into/bulkcopy single user subscribed torn page detection trunc. log on chkpt. Then there is this: To set this option for all databases, follow these steps: Right-click <server>. Click to select Properties. Click Security. Click to select Allow cross-database ownership chaining in the Ownership chaining section. Click OK. You are prompted to stop and restart the SQL Server services. Click OK. In the Security section there is nothing labled "Allow cross-database ownership chaining" nor an "Ownership chaining" section. Also there is: To enable this option at the database level, follow these steps: Right-click the <database>. Click to select Properties. Click Options. Click to select Allow Cross Database Ownership Chaining in the Settings section Again, there is nothing like this. In the MS SQL Sserver properities it seems to say that it is at SP 3. However, I cannot figure out how to enable the DB chaining. What can I do? Do I need to removed and reinstall the whole MS SQL Server? Any help is greatly appreaciated. Regards, Jim Mohr ELAXY Brokerage & Trading GmbH & Co KG _________________________________ James Mohr Systembetrieb Am Hofbr�uhaus 1 96450 Coburg Germany Fon +49 (0) 95 61.55 43.0 Fax +49 (0) 95 61.55 43.302 E-Mail: [EMAIL PROTECTED] --------------------------------------- "Be more concerned with your character than with your reputation. Your character is what you really are while your reputation is merely what others think you are." -- John Wooden --------------------------------------- Be sure to visit the Linux Tutorial: http://www.linux-tutorial.info _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo
