Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I need to view the tables and data in a MSSQL 2008 DB.

What is the easiest way to connect to it and view the schema and data?

I have Visual Studio 2008 Team System, is there a tool built in to that. Or is there something else I need to use?

share|improve this question
add comment

3 Answers

up vote 4 down vote accepted

SQL Server comes with "SQL Server Management Studio", which lets you view the schema, data, users, execute queries, do profiling, etc.

You can do an installation on your VS machine with just the SQL server client/workstation components. Kendal Van Dyke has a blog post that will walk you through it.

share|improve this answer
add comment

I can't remember if Team Studio includes SQL Management Studio. If it doesn't and if you don't have access to the SQL Server install media then use Microsoft SQL Server Management Studio Express, which is a free download from www.microsoft.com/downloads.

This seems to one of those well kept secrets. Microsoft SQL Server Management Studio Express isn't as powerful as the full Management Studio but it's a very useful tool and will manage SQL 2005 and 2000 as well as 2008.

JR

share|improve this answer
add comment

SQl server mangement studio has the ability to generate database diagrams. Click on a database in object explorer and then click on the database diagram folder.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.