Multiple Forums - SQL Server

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Duval Members Profile Find Members Posts Newbie Joined: 02 December 2004 Status: Offline Points: 22	Post Options Post Reply Quote Duval Report Post Thanks(0) Quote Reply Topic: Multiple Forums - SQL Server Posted: 05 December 2004 at 8:26pm
	Can I have multiple forums on the same server space from one db? 7.9 SQL Server

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply Posted: 05 December 2004 at 9:02pm
	Yes, you can just change the table prefix in the configuration steps...
	Blog \| MPG Tracker

Duval Members Profile Find Members Posts Newbie Joined: 02 December 2004 Status: Offline Points: 22	Post Options Post Reply Quote Duval Report Post Thanks(0) Quote Reply Posted: 05 December 2004 at 10:07pm
	Michael, Thanks! This is just getting better by the day.

dpyers Members Profile Find Members Posts Senior Member Joined: 12 May 2003 Status: Offline Points: 3937	Post Options Post Reply Quote dpyers Report Post Thanks(0) Quote Reply Posted: 05 December 2004 at 10:07pm
	The other issue with using the same server space is that you'd need to turn off application variables for one of the forums (There's threads on how to do that). The workaround to enable application variables for all forum instances forums is to have any additional forums in their own sub domains - but you can still use the same db with the change michael noted.
	Lead me not into temptation... I know the short cut, follow me.

dpyers Members Profile Find Members Posts Senior Member Joined: 12 May 2003 Status: Offline Points: 3937	Post Options Post Reply Quote dpyers Report Post Thanks(0) Quote Reply Posted: 05 December 2004 at 10:12pm
	EDIT to my previous post. Where I talked about resolving the application variable problem by putting additional forums in sub domains, I should have said in sub domains or in separate domains.
	Lead me not into temptation... I know the short cut, follow me.

Duval Members Profile Find Members Posts Newbie Joined: 02 December 2004 Status: Offline Points: 22	Post Options Post Reply Quote Duval Report Post Thanks(0) Quote Reply Posted: 06 December 2004 at 8:10am
	In reality all instances would be from unique sites on the same server so would it be safe to assume that I'd be OK with the application variable issue?

dpyers Members Profile Find Members Posts Senior Member Joined: 12 May 2003 Status: Offline Points: 3937	Post Options Post Reply Quote dpyers Report Post Thanks(0) Quote Reply Posted: 06 December 2004 at 8:45am
	Yup. Each domain/sub domain is a separate application so it will have it's own application variables.
	Lead me not into temptation... I know the short cut, follow me.

Duval Members Profile Find Members Posts Newbie Joined: 02 December 2004 Status: Offline Points: 22	Post Options Post Reply Quote Duval Report Post Thanks(0) Quote Reply Posted: 06 December 2004 at 10:36am
	Thanks michael & dpyers. Much appreciated.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.