Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Database > Microsoft SQL Server
Reload this Page

Where can I get SQL Analyzer or FREE equivalent?

Discuss Where can I get SQL Analyzer or FREE equivalent? in the Microsoft SQL Server forum on ASP Free.
Where can I get SQL Analyzer or FREE equivalent? Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old September 8th, 2003, 12:37 PM
prdc prdc is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Sep 2003
Posts: 4 prdc User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Where can I get SQL Analyzer or FREE equivalent?
I am trying to install an ASP (Visual Basic) application. It uses a Microsoft SQL database.

The installation instructions are:

1. unzip the .zip file to a Web shared (alias or virtual created via IIS) folder
2. create a database on your SQL server
3. execute the included portal.sql script on the new database
4. update the database connection strings in config.asp for your SQL server database

I completed steps 1 and 2. Now I must exicute portal.sql.

How can I exicute portal.sql? I called my hosting company and they said that they do not provide any tools to do this but I should download SQL Analyzer.



Where can I download SQL Analyzer?

If it is not free, is there a free tool that could be used, if so, where could I download it?

Thanks!
Reply With Quote
  #2  
Old September 8th, 2003, 02:03 PM
dcarva's Avatar
dcarva dcarva is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Jan 2003
Location: USA
Posts: 633 dcarva User rank is Lance Corporal (50 - 100 Reputation Level)dcarva User rank is Lance Corporal (50 - 100 Reputation Level)dcarva User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 9 h 18 m 20 sec
Reputation Power: 6
If you have SQL Server installed, then you should have SQL Query Analyzer installed as well. Go to Start->Programs->MS SQL Server->Query Analyzer.
Reply With Quote
  #3  
Old September 8th, 2003, 02:15 PM
prdc prdc is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Sep 2003
Posts: 4 prdc User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
I don't have SQL Server installed. I am hosting my script with WebHost4Life and they offer MS Sequal support but they don't provide SQL Server.

Is there any good free software that will work?
Reply With Quote
  #4  
Old September 8th, 2003, 02:23 PM
dcarva's Avatar
dcarva dcarva is offline
Contributing User
ASP Free Novice (500 - 999 posts)
  
Join Date: Jan 2003
Location: USA
Posts: 633 dcarva User rank is Lance Corporal (50 - 100 Reputation Level)dcarva User rank is Lance Corporal (50 - 100 Reputation Level)dcarva User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 9 h 18 m 20 sec
Reputation Power: 6
Ok. I will look, but you wrote:

"2. create a database on your SQL server "

How did you create the database on the WebHost4Life server? I doubt that you can simply download SQL Server Query Analyzer as standalone. If you do get such a tool, you still need to be able to connect directly to their SQL Server so that you can remotely run the .sql file, or run the file locally then transfer the results over to their server...
Last edited by dcarva : September 8th, 2003 at 02:34 PM.
Reply With Quote
  #5  
Old September 10th, 2003, 12:10 PM
Andrew Andrew is offline
dotNetBB Forums Developer
ASP Free Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Posts: 265 Andrew User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
Send a message via ICQ to Andrew Send a message via AIM to Andrew Send a message via Yahoo to Andrew
I usually suggest CuteSQL for people who need a free replacement for SQL QA. You can find it at http://www.casestudio.com/enu/bonus.aspx.
Reply With Quote
Reply

Viewing: ASP Free Forums > Database > Microsoft SQL Server > Where can I get SQL Analyzer or FREE equivalent?

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway.