Which version of sql server allows building queries in a graphical GUI ?
I just found how to create diagrams: 1. Launch SQL Server Management Studio Express 2. Connect to the appropriate server 3. Expand the specific database that you want to diagram 4. Right-click Database Diagrams and choose New Database Diagram 5. Highlight one or more tables you want to include in the diagram, and then click Add followed by Close
Kiewic
2009-09-22 08:08:19
This doesn't seem to support any inprocess database servers (SQLite, SQL Server Compact Edition, db4o, etc).
overslacked
2009-04-04 20:08:42
A:
There are 3 different versions you can download... SQL Server Express
SQL Server 2008 Express is available in the following 3 editions (each is available from the Install Wizard):
SQL Server 2008 Express with Tools SQL Server database engine - create, store, update and retrieve your data SQL Server Management Studio Basic - visual database management tool for creating, editing and managing databases
SQL Server 2008 Express with Advanced Services SQL Server database engine - create, store, update and retrieve your data SQL Server Management Studio Basic - visual database management tool for creating, editing and managing databases Full-text Search - powerful, high-speed engine for searching text-intensive data Reporting Services - integrated report creation and design environment to create reports
SQL Server 2008 Express (Runtime Only) SQL Server database engine - create, store, update and retrieve your data
SQL Server 2008 Management Studio Express (SSMSE) Free, easy-to-use graphical management tool for configuring, managing, and administering SQL Server 2008 Express. It can also manage multiple instances of the SQL Server Database Engine created by any edition of SQL Server 2008 including Workgroup, Web, Standard and Enterprise.
Alan FL
2009-04-04 19:43:29
Is the expres free edition is good for customers that have database with over 1 milion records and 20 users entrance ?
Gold
2009-04-04 20:09:52
the only restriction you'll have apart from some restrictions in the administration is that the dbs can't be bigger than 4Gb i think...
Alan FL
2009-04-04 22:00:48