mssqlXpress 1.3.0.6

4.4 out of 5 stars 4.4 (16 votes)

(March 17, 2004)

Windows 2000/2003/9x/XP / Shareware / 2,071 downloads

mssqlXpress delivers to the developer a tool that combines the best features of Enterprise Manager and Query Analyzer with even more features. Ability to retain history of all changes to stored procs, triggers, and databases. MDI interface to enable the easy copying and pasting of code between objects. Script generation with them been stored to a database for easy retrival.

  • Publisher

    Speciality Applications

  • Homepage

    mssqlXpress

  • Latest Changes

    - Added- Ability to define and call External Applications

    - Added- You can now open a view the same way you can open a table

    - Added- Ability to disable/enable triggers with a mouse click

    - Added- Status of last execution on the SQL Editor

    - Added- Can now permanently delete deleted items from mssqlXpress. We only recommend doing this if your are absolutely sure you do not need the history of the deleted item as it will be unrecoverable

    - Added- User option to only list database you have access to

Reviews of mssqlXpress

  1. 5 out of 5 stars
    mrgrieves

    Reviewing 1.2.9.5 (Mar 17, 2004)

    (For 1.3.0.6) - this application just keeps improving. The XML support is now first class and they have added quite a few other new features that are really useful.

    I think my only complaint now is that occasionally the interface can be a little clumsy - editing tables (both structure and data) is not always as easy as it should be.

    But I would be surprised if these things weren't polished up more as time goes on as the developers are very quick to respond and keen to deliver a quality product. (Which they have..)

  2. 5 out of 5 stars
    mrgrieves

    Reviewing 1.2.7 (Sep 9, 2003)

    Absolutely brilliant. Replaces both Microsoft SQL Enterprise Manager and Query Analyzer and adds some hugely useful features of its own - autocomplete, version history, sourcesafe integration etc.

    My only complain is that FOR XML AUTO doesn't work properly (although the app can generate its own XML).

    But the developers are extremely friendly and response quickly to bugs and are very open to feature requests so I'm sure they will fix this one.

    I'm looking forward to seeing what they come up with next.

  3. 5 out of 5 stars
    mbgrove

    Reviewing 1.05 (Apr 30, 2003)

    Since Kortirion appears to have covered the program itself rather well, I'll branch out. :-)
    Like Kortirion, I have been using mssqlXpress since it first came out in beta. Like all programs in beta, it had some problems, but it definitely had potential. And the team at SpecApps have done an /awesome/ job of attaining that potential. You won't meet a more responsive development company. In looking back at how mssqlXpress has evolved, it is easy to see how much they listen to their customers. With SpecApps, you won't look back.

  4. 5 out of 5 stars
    kortirion

    Reviewing 1.05 (Apr 29, 2003)

    I wrote the first nasty review of this program (see bottom) and my, how things have changed. I have no idea why I was so pissed, but I actually have ended up using it daily ever since the release following that review. Great program, has removed almost all need for both QA and EM in our shop and everyone is required to use it. Updates are regular and actually add quite a few new features. It is still in active development, one of the newest features being an execution plan simliar to QA's.

    It's got table structure editing, a data editor, query builder, code complete (visual studio style), reports, templates, an awesome 'verify' feature which is better than syntax check, and tons of other stuff I can't even remember right now. Just keeps getting better.

    Keep QA around in case you need to run the indexing wizard or use a few of it's other features that haven't made it over yet.

    It does require that you run the 'server' install to create a database, so you do need to have a sql server you can add it's database too. Keeps trak of the servers you connect to, vss settings, etc. there.

  5. 5 out of 5 stars
    Andrei Rantsevich

    Reviewing 0.996a (Feb 17, 2003)

    Could be a good substitute for Query Analyzer. It has a lot of extra features, like Source Code sontrol through VSS and code complete assistant, and what is also important - it is constantly developed and improved - even upon individual wish (if your request is really reasonable). We currently have switched to this product and currently Query Analyzer is needed only for Debug and Execution Plan.

Discuss mssqlXpress