MSSQL server 2005..How to browse data using Management studio

hey guys

I am playing around with mssql and I got it working fine with php. However I am used to mysql and its a little different in MSSQL. In my sql if I use the Administration tool, it lets me browse the tables for the data. However in MSSQL if I use the SQL Server management tool, it does not let me browse the data, instead it gives me the column names. I was wondering if there is any way to browse the data. I would need step by step instructions for that as I am new to the SQL Management tool. Also is there any think like phpmyadmin for MSSQL?

Thanks
LVL 9
syedasimmeesaqAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
Hello syedasimmeesaq,

Right click on the table and select Open table


Aneesh R
0
 
Jaime OlivaresConnect With a Mentor Software ArchitectCommented:
Besides the Aneesh's suggestion, you can query directly.
Open a new Query Window, pressing the "New Query" button, then write:
     USE yourDBName;
     SELECT * FROM yourTableName;
Press F5
0
 
cottsakCommented:
step 1) connect to database
ftp://eatflesh.dyndns.org/view1.jpg

step 2) navigate to table thru Object Explorer, right click on table, select "Open Table"
ftp://eatflesh.dyndns.org/view2.jpg
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.