Urgent: MS SQL 8.0 query browser

Hello,

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

Yes, either QA or EM will give you that information.

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

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.

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?

Hello,

Thanks a mill for all the help.

Zac

Hello,

I have SQL Server 2000 (8.0).

Thanks,
Zac