return all rows function

in sql 2000 there is the return all rows function.. where is it in sql 2005 express or does it have that function?

thanksI'm a bit confused by your post; can you explain where this function is and how you use it? I have a feeling you're referring to a feature by a different name than is normally used. -- Adam MachanicPro SQL Server 2005, available nowhttp://www..apress.com/book/bookDisplay.html?bID=457-- <erd@.discussions.microsoft.com> wrote in message news:ddefbe4d-f12b-489e-9ccf-7422d416a908@.discussions.microsoft.com...in sql 2000 there is the return all rows function.. where is it in sql 2005 express or does it have that function?thanks|||Something like this function in Enterprise Manager for SQL Server 2000 should be available to you in Management Studio Express. Failing that, just run the query, SELECT * FROM table? It's really not that much more work than right-click, select... A wrote in message news:ddefbe4d-f12b-489e-9ccf-7422d416a908@.discussions.microsoft.com...
> in sql 2000 there is the return all rows function.. where is it in sql
> 2005 express or does it have that function? >
> thanks
>|||You can right click on your table or view in Object Explorer and select Open Table/View in the context menu. This open a query editor instance with all the data in your table or view.

Is this what you were looking for?|||yes.. thats the one.. thank you

i have another problem..

we are currently using an sql 2000 in server and installed sql server 2005 express on one client but whenever we right click the database diagram in of of our client machine we are having an error.

The system cannot find the specified path exception from HRESULT 0x800700002 (Microsoft.VisualStudio.VSHelp80)|||

Which server is the diagram on and which client is doing the clicking? Are you clicking on a particular diagram, or on the diagrams folder?

The database designer in SQL Server 2000 doesn't understand SQL Server 2005 diagrams. Conversely, the database designer in SQL Server 2005 can't work with diagrams on SQL Server 2000 servers.

|||

where is the import/export function in sql server 2005 express edition?

trying to import an access file or .mdb file to sql 2005 express but couldnt find how to import it.. and also the export file..

thanks