sacul
asked on
Urgent: MS SQL 8.0 query browser
Hello,
Is there a utility similar to mySQL's query browser for Microsoft SQL Server 8.0?
Thank you,
Zac
Is there a utility similar to mySQL's query browser for Microsoft SQL Server 8.0?
Thank you,
Zac
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, either QA or EM will give you that information.
ASKER
Hello,
Thanks for the quick answer. I have one last question. How can I get eight QA or EM? Is there a free download/trial or do I have to purchace the program?
Thank you,
Zac
Thanks for the quick answer. I have one last question. How can I get eight QA or EM? Is there a free download/trial or do I have to purchace the program?
Thank you,
Zac
Both are part of the purchased program. If you are running SQL Server Express you do have the option of downloading the Management Studio Express
That can be found here: http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en
Please check the system requirements.
There are also a few SQL tools that are free (google FREE SQL Server tools), but I do not have much experience with them.
That can be found here: http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en
Please check the system requirements.
There are also a few SQL tools that are free (google FREE SQL Server tools), but I do not have much experience with them.
SQL Server Express is 9.0 and it is free at: http://msdn.microsoft.com/vstudio/express/sql/
Which version of SQL Server do you have?
Which version of SQL Server do you have?
ASKER
Hello,
Thanks a mill for all the help.
Zac
Thanks a mill for all the help.
Zac
ASKER
Hello,
I have SQL Server 2000 (8.0).
Thanks,
Zac
I have SQL Server 2000 (8.0).
Thanks,
Zac
ASKER
What I need to do is to connect to a MS SQL server that is running on a network for a custom reporting application. I have done this in the past with mySQL and used mySQL Query Browser. By using it I could find out the database and table names to connect a VB.NET application to it. Is there a way to find out the same information for a MS SQL server to see the structure of database and find out the table name(s) so I can connect an application to it? I have access to all the passwords needed to connect to the MS SQL server through the existing application
Thank you,
Zac