SQL Query

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Corey Bryant Members Profile Find Members Posts Newbie Joined: 14 December 2004 Status: Offline Points: 18	Post Options Post Reply Quote Corey Bryant Report Post Thanks(0) Quote Reply Topic: SQL Query 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!

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Corey Bryant Members Profile Find Members Posts Newbie Joined: 14 December 2004 Status: Offline Points: 18	Post Options Post Reply Quote Corey Bryant Report Post Thanks(0) Quote Reply 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

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.