|
Here are a few good options.
Tools include:
- SQL Server Management Studio
- SQL Server Management Studio Express (free)
- Visual Web Developer Express Edition (free) which includes mature database management tools
- Many 3rd party tools will work with SQL Server 2005
SQL Server Management Studio can be installed independently on a computer running client/server applications that connect directly to an instance of SQL Server 2005 by running the SQL Server 2005 installation and only selecting ‘Client Components’ to install.
The Client Components option installs the following SQL Server features:
- Command prompt tools
- Report Server tools
- Connectivity components
- Programming models
- Management tools
- Development tools
- Books Online
- Sample databases
- Sample applications
SQL Server Management Studio:
SQL Server Management Studio can be used to manage SQL Server 2005 systems as well as SQL Server 2000 and SQL Server 7.0. It cannot be used to manage SQL Server 6.5 or older systems. A valid license of SQL Server 2005 is required to install the tools.
Microsoft SQL Server Management Studio Express:
Microsoft SQL Server Management Studio Express (SSMSE) provides a graphical management tool for SQL Server 2005 Express Edition (SQL Server Express) instances. SSMSE can also manage relational engine instances created by any edition of SQL Server 2005. SSMSE cannot manage Analysis Services, Integration Services, SQL Server 2005 Mobile Edition, Notification Services, Reporting Services, or SQL Server Agent.
Visual Web Developer 2005 Express Edition:
Visual Web Developer 2005 Express Edition is a lightweight, easy-to-use and easy-to-learn development tool focused exclusively on Web development. You will find that it encompasses everything needed to begin building exciting, dynamic web applications with ASP.NET 2.0.
3rd Party SQL Management Tools:
SQLExecMS is a program having almost everything DBA or developer needs to work with MS SQL Server or MSDE. It offers variety of functions from development via tuning up to the deployment and data manipulation.
Apex SQL Studio Universal is a comprehensive and powerful suite of ALL of our SQL Server tools offered at a great, discount price. The Studio suite offers developers a wide range of must-have functionality including Auditing, Scripting, Comparison & Synchronization, Reporting, Documentation, Code Generation, Data Recovery, Editing/IDE and more.
Note: Enterprise Manager cannot be used to manage a SQL Server 2005 Database.
| 
