DataRide partners with MyLittleTools.net to deliver Web-Based SQL Enterprise Manager. See a live demo here.

myLittleAdmin for SQL Server and MSDE is a web-based SQL Server administration tool. It is intended to handle the administration of SQL Server and MSDE databases over the WWW. It allows you to fully manage your databases even when you don't want or cannot use MS Enterprise Manager.

With myLittleAdmin, you will do through a browser almost everything you did before with Enterprise Manager. myLittleAdmin is the best solution to remotely administer SQL Server and MSDE.

myLittleAdmin Features:

Databases

• List
• Display space use

Tables

• List
• Data search
• Quick data edit
• Create, delete, rename, generate SQL script
• Export data to character-delimited files or XML files

Columns

• List
• Create, delete, rename, edit

Indexes

• List
• Create, delete, rename, generate SQL script
• Rebuild

Relationships (Foreign Keys)

• List
• Create, delete, rename, generate SQL script

Triggers

• List
• View T-SQL
• Create, delete, rename, edit, generate SQL script

Constraints (Checks)

• List
• Create, delete, rename, edit, generate SQL script

Views

• List
• View T-SQL
• Data search
• Create, delete, rename, edit, generate SQL script
• Export data to character-delimited files or XML files

Stored procedures

• List
• View T-SQL
• Create, delete, rename, edit, generate SQL script

Users

• List

Roles

• List

Rules

• List
• Create, delete, rename, generate SQL script
• Link to UDT and columns

Defaults

• List
• Create, delete, rename, generate SQL script
• Link to UDT and columns

User defined types (UDT)

• List
• Create, delete, rename, edit, generate SQL script

User defined functions (UDF)

• List
• View T-SQL
• Create, delete, rename, edit, generate SQL script

Tools

• Query analyser

Options

• Multi languages
• Multi skins