Unix Technical Forum

management tool express 2005

This is a discussion on management tool express 2005 within the SQL Server forums, part of the Microsoft SQL Server category; --> It there a way to view tables in 2005 express edition? I know I can write a query but ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 09-20-2008, 06:14 PM
Alex Pavluck
 
Posts: n/a
Default management tool express 2005

It there a way to view tables in 2005 express edition? I know I can
write a query but I seem to recall seeing the ability to bring up a
table view - though it was on the full SQL server edition.

If not, is the a commercial tool? Will 2008 express provide this
functionality?

Thanks, Alex
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 09-20-2008, 06:14 PM
Plamen Ratchev
 
Posts: n/a
Default Re: management tool express 2005

You should be able to right click on a table and select Open Table. But
it is much better to use the Query window to select from the table. The
graphical table tools are really not the best way. Just add a BIT column
to one table and see if you can type 0 or 1 in the open table screen
(and those are supposed to be the values for BIT data type).

--
Plamen Ratchev
http://www.SQLStudio.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads for: management tool express 2005

Thread Thread Starter Forum Replies Last Post
SQL 2005 Management Studio/Express - Any differences John Fox SQL Server 2 09-12-2008 05:23 PM
SQL 2005 Express =?Utf-8?B?R2VuZQ==?= MS SQL ODBC 2 08-15-2008 03:23 PM
Newbie on permissions: ADO.NET, C++.NET, SQL SERVER 2005 EXPRESS, Visual Studio 2005 raylopez99 SQL Server 9 03-01-2008 02:47 PM
Management Studio Express Maury SQL Server 1 02-29-2008 07:54 PM
MS SQL 2005 Express Jassim Rahma SQL Server 3 02-29-2008 08:16 AM


All times are GMT. The time now is 05:12 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com