MSDE Manager

MSDE Manager - the complete MSDE and SQL Manager.

MSDE Manager allows you to do all of the common operations that a typical deployment of MSDE/SQL would entail, and much more besides.

MSDE Manager has an easy to use updated graphical user interface, a Transact SQL screen and auto Web updating to keep users on the most recent version.

MSDE Manager has in-built help. 2000 and 97 Versions selectable on installation.

Here are some key features of "MSDE Manager":

￭ Add/Edit/Delete databases. ￭ Add/Edit/Delete tables. ￭ Add/Edit/Delete views. ￭ Add/Edit/Delete roles. ￭ Add/Edit/Delete rules. ￭ Add/Edit/Delete stored procedures. ￭ Add/Edit/Delete defaults. ￭ Add/Edit/Delete functions. ￭ Add/Edit/Delete user defined datatypes ￭ Complete Table designer to add/edit/delete/cut/copy/paste columns. ￭ Set primary keys ￭ Set triggers ￭ Set indexes ￭ Set constraints ￭ Change server properties (e.g. authentication mode etc.). ￭ Change column properties. ￭ View/Edit/Export data in the data management section. ￭ Import/Export/Execute DTS packages. ￭ Create and Schedule jobs. ￭ Backup & Restore Databases. ￭ Attach, Detach and Shrink databases. ￭ Complete Full TSQL module with quick select function list/colour coded TSQL. ￭ Relationships management screen for foreign keys etc. ￭ Transfer database wizard to transfer form server to server.

Limitations:

￭ 7 days trial ￭ Nag screen