March 31, 2008 at 6:22 pm
Hello, all -- I am really new to SQLEXPRESS.
I have upsized one of my ACCESS2000-mdb into SQLSrvr.
The only way I have been able to "see" the data is to open VB.netExpress2008 and use the DataExplorer to see the table data.
I guess I am asking if SQL-express has an ACCESS-like user interface to allow me to alter table-layouts, enter queries (I think these are like Stored procedures?) Sets? and other DB-maintenance functions.
Thanks, in advance...John
April 1, 2008 at 8:06 am
Hi,
Welcome to sqlservercentral 🙂
Yes you are correct, SQLExpress also provides GUI to alter or to enter data's into table. For SQLExpress you need to download & Install SQL server management studion express, you can refer the below link to download. Once this installed you can connect to SQLExpress and do your needs..
SQL Server Management Studio Express
Regards..Vidhya Sagar
SQL-Articles
April 1, 2008 at 8:44 am
Once you get SSMS, you need to "Connect" to your instance since you're working in client server mode now. SSMS won't "Open" the database.
Go to Databases, expand that, then expand "Tables, pick your table and right click. There are a number of options, including "opening" the table for browsing.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply