sql server msde: Viewing table rows in Microsoft's Web Data Administrator for MSDE -- sql server msde

Re: Viewing table rows in Microsoft's Web Data Administrator for MSDE

Andrea Montanari
5/28/2005 12:00:00 AM

sql server msde:

hi,
[quoted text, click to view]

I'm not used to WDA, but I do think it only allows to show you the result of
a specific "manual" SELECT statement..
that's to say you have to query your view in order to see it's result...
SELECT * FROM dbo.yourView
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Viewing table rows in Microsoft's Web Data Administrator for MSDE

plum
5/28/2005 7:39:51 AM

Hi

I'm using the Microsoft Web Data Administrator (WDA) to access MSDE.
I've created a table and inserted values into it. When I click on my
table with inserted values in WDA, I can see details on the attributes
of each column, but not the values.

If I osql into my MSDE, I can see the values have been inserted through
a "SELECT * from tablename".

Am I blind or does WDA not show you table values/rows?

--PLum