Web Wiz Forums - SQL Query

Print Page | Close Window

SQL Query

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=13016
Printed Date: 11 April 2026 at 6:11pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Query

Posted By: Corey Bryant
Subject: SQL Query
Date Posted: 16 December 2004 at 11:46pm

After severe problems upsizing, it seems that there is one post here that talks about the way to do it. So no problems, right? Well now I have gone in, deleted database & recreated a datase (different names, etc) a dozen times. Yet when I run that MSSQL Database set-up, it tells me eror creating the tables - they exist (maybe). But it is a new database.

Do you have the SQL query that I can run to create the tables & the Stored Procedures?

Thanks!

-------------
Corey
http://www.loudcommerce.com - Merchant Accounts

Replies:

Posted By: WebWiz-Bruce
Date Posted: 17 December 2004 at 5:27am

The query that is run to create the table is in the SQL setup file, and there are many of them.

If you are getting errors and the tables are not created then it sounds like the SQL srever user you are using does not have permission to create tables on the MS SQL server.

-------------
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: Corey Bryant
Date Posted: 17 December 2004 at 8:13am

Thanks. I finally got it - by actually re-uploading the the ASP scripts. Just some other issues with the FK information or something like that

-------------
Corey
http://www.loudcommerce.com - Merchant Accounts