Popular Posts

  • Changing the button's Properties
    Changing the button's Properties Now you have a button on your form. You can change its location by dragging it, and change its size by ...
  • DOT NET PAPER PRESENTATION
    Dot Net Publish at Scribd or explore others: Presentations & Slid ...
  • Simple Data Binding With ADO.NET
    Simple Binding Data Binding Data Binding is binding controls to data from the database. With data binding we can bind a control to a partic...
  • Learning about Events (Continue)
    Learning about Events (Continue) Lets program the Form_Load event. "MsgBox" is Visual Basic command that launch a message box. for...
  • JSP Scripting Elements
    JSP scripting elements let you insert Java code into the servlet that will be generated from the current JSP page. There are three forms: ...
  • Example Using Scripting Elements and Directives
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <TITLE>Using JavaServer Pages...
  • Table Comparing C, C++ and Java
    FEATURE C C++ JAVA Paradigms Procedural Procedural, OOP, Generic Programming OOP, Generic Programming (from Java 5) Form of Compiled Sour...
  • Limitations of SQL Server Express
    SQL Server Express is a free, easy to use, redistributable version of SQL Server 2005 designed for building simple data-driven applications....
  • Loops in VB.NET
    Loops For Loop The For loop is the most popular loop. For loops enable us to execute a series of expressions multiple numbers of times. The ...
  • Object oriented Programming CLASS(II)
    Classes (II) Overloading operators C++ incorporates the option to use standard operators to perform operations with classes in addition to w...

Wednesday, March 18, 2009

SQL Management Studio Editions

SQL Management Studio comes in two flavours:

1. SQL Management Studio

This edition comes with all versions of SQL Server 2005 except SQL Server 2005 Express Edition. This edition has various advanced features like import data from other database systems, export data to other databases etc.

2. SQL Management Studio Express

SQL Management Studio Express is part of SQL Server 2005 Express Advanced edition. You can download Management Studio Express as a separate tool also. Some of the key features like Import data, export data etc are missing in the Express edition of Management Studio.

For learning purposes and development purposes, the express edition serves the purpose. After all, it is FREE !

The non express edition of the management studio is also free when you purchase non express editions of SQL Server 2005, but you have to pay several thousand dollars for the SQL Server license.
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)