Well of course my SQL database is with my host. I'm having a problem trying to run some SQL scripts for the ASP.NET portal that is provided on this site. They suggested using the MySQL control center or some other MySQL program, but neither of them will run
the .sql scripts because of the syntax. Is there another solution to running the scripts. They suggest SQL query analyzer, but I don't have access to the server directly...????
- km
______________________________________
"always here and always forever"
griff303
Contributor
2811 Points
777 Posts
SQL program problem...
Feb 28, 2005 01:35 PM|LINK
______________________________________
"always here and always forever"
Ken Schaefer
Participant
2000 Points
400 Posts
ASPInsiders
MVP
Re: SQL program problem...
Apr 13, 2005 01:34 PM|LINK
If the relevant ports are open on the SQL Server box, you can connect using Query Analyser on your local machine to the remote SQL Server.
Alternatively, Microsoft has a web-based enterprise manager for SQL Server that you could install onto your server:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
Cheers
Ken