Web Wiz Forums - Stored Procedures in 7.97

Print Page | Close Window

Stored Procedures in 7.97

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=18544
Printed Date: 13 April 2026 at 6:52am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Stored Procedures in 7.97

Posted By: DeadMeat
Subject: Stored Procedures in 7.97
Date Posted: 01 March 2006 at 10:13am

Is there any way to turn off the stored procedures in version 7.97 and use straight SQL statements. The reason for this is because the server that we are trying to run it on does some really strange things with stored procedures.

Thanks

Replies:

Posted By: WebWiz-Bruce
Date Posted: 01 March 2006 at 11:11am

There is not a way to do this in version 7.x, but in version 8 stored procedures have been dropped as in performance tests they didn't offer any noticeable performance advantage.

Also, but not using stored procedures more SQL queries can be created on the fly allowing more powerful and configurable options for users.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: DeadMeat
Date Posted: 02 March 2006 at 7:21am

Hi Borg

Thanks for the reply, I suppose the only obviouse question is now one of when are we likely to see the version 8? As I woudl really like to use this forum, but can't use SPs in SQL, so I guess I'm just gonna have to wait.

Thanks

Posted By: WebWiz-Bruce
Date Posted: 02 March 2006 at 10:52am

Version 8 beta 2 was released for testing yesterday.

So far either beta 2 is quite stable or people are not yet reporting errors.

If beta 2 proves to be quite stable I hope to have the full version out by this Easter.

Posted By: DeadMeat
Date Posted: 02 March 2006 at 12:07pm

Hi Borg

Thanks appreciate it. If I may ask is there a list somewhere of extras that you are planing to add to the the forum? I have seen the list of items that you have added to Beta2, but do you have a list somewhere of extras that you plan to implement?

Thanks
DM

Posted By: WebWiz-Bruce
Date Posted: 02 March 2006 at 12:09pm

forum_posts.asp?TID=13860 - Version 8 Development Blog

Posted By: DeadMeat
Date Posted: 02 March 2006 at 12:22pm

Excellent.

Thank you good sir, I look forward to version 8, in the mean time, I will attempt to get 7.97 working with SPs. So that I can get a demo version of my site up and running.

Thanks

Posted By: WebWiz-Bruce
Date Posted: 02 March 2006 at 12:27pm

You need to configure your user account on the SQL Server to be a member of the DBO group so that you can run stored procedures found in Web Wiz Forums.