Execute .sql file
Printed From: Web Wiz Forums
Category: Web Wiz Hosting Services Forums
Forum Name: Web Wiz Hosting Support Forums
Forum Description: Support forum for Web Wiz Hosting services and solutions.
URL: https://forums.webwiz.net/forum_posts.asp?TID=29021
Printed Date: 28 March 2026 at 9:35am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Execute .sql file
Posted By: azqh
Subject: Execute .sql file
Date Posted: 14 December 2010 at 9:35am
|
"Execute the admin.sql script in order to create the tables and stored procedures in the database". I'm a new completely newbie to web wiz hosting and its format of style to complete tasks. I need someone to help me upload my file to execute the .sql file to my SQL Server 2008. the only option I can find to upload a file is only asv file but??
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 14 December 2010 at 11:03am
|
There are a number of ways this can be achieved, it maybe worth asking the developers how they intend the file to be run. You could install SQL Server Management Studio on your own PC then connect remotely to your database and use the Tools in SQL Server Management Studio to execute the SQL file. Another alternative is to use the Tools available in your Control Panel. Next to the name of your SQL Server database you will find a 'Browse Database' link this will take you to the myLittleAdmin Tool, from where under the 'Tools' menu you will find a 'New Query' tool. you can then copy and paste the code from your admin.sql file to the 'New Query' form and hit the submit button to execute the code. If you are still stuck create a support ticket from your Client Area account and attach your admin.sql file and we can look at executing it for you. ------------- 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: azqh
Date Posted: 14 December 2010 at 12:05pm
|
Okay I copied and pasted the contents to it and it did create tables now I am uploading all the files and we will see if it works! |
! I've tried to access with express studio says I do not have access to anything with my assigned database...Posted By: WebWiz-Bruce
Date Posted: 14 December 2010 at 12:49pm
|
Could you please create a support ticket on this so can have a look at your database to make sure that the tables have been created correctly? ------------- 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: azqh
Date Posted: 14 December 2010 at 8:19pm
|
yes I can but I did get up and working now everything is okay. when I did create the tables it worked and put them in but in the messages it said a few errors. |
Posted By: WebWiz-Bruce
Date Posted: 14 December 2010 at 9:00pm
|
Good to hear that it is working ------------- 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 |