Solved

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

Posted on 2007-11-28
3
238 Views
Last Modified: 2010-03-19
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
0
Comment
Question by:syedasimmeesaq
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 250 total points
ID: 20371277
Hello syedasimmeesaq,

Right click on the table and select Open table


Aneesh R
0
 
LVL 55

Assisted Solution

by:Jaime Olivares
Jaime Olivares earned 250 total points
ID: 20371335
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
 
LVL 6

Expert Comment

by:cottsak
ID: 20371431
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

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question