myLittleAdmin for SQL Server 2005 3.1

myLittleAdmin for SQL Server 2005 3.1 is a software  able to monitor most objects of MS SQL Server databases and servers via a web browser, which can work with the best hosting control panels such as Plesk, DNP, Helm, or stand-alone. This tool offers a reliable, efficient and secure solution to manage SQL Server databases in a (web) hosting environment that has already seduced hundreds of hosting providers and IT companies.

Web-based application

• myLittleAdmin for SQL Server is a web-based application. It means that it can be accessed from any Internet connected computer anywhere in the world, from work, at home or on the move.

High level of configuration

• Each feature of myLittleAdmin can easily be enabled or disabled so that hosters can choose the functionalities they want to offer to their customers.

Server and database objects management

• Almost all server and database objects can be managed through myLittleAdmin. It includes the standard objects like tables, views, stored procedures, indexes, constraints, functions, triggers, users, permissions, etc. but also new SQL Server objects like Database Snapshots, Synonyms, Credentials, etc.

Database content management

• myLittleAdmin includes a powerful editable datagrid that allows editing and deleting records while browsing your data. MyLittleAdmin also offers the possibilities to export data into XML, XLS and CSV formats

Powerful tools and wizards

• myLittleAdmin includes several powerful tools and wizards that will help your customers in their daily work.
• The "New query" tool allows running T-SQL statements. The "Generate INSERT" wizard offers the possibility to generate T-SQL insert statements for a complete table content in a couple of clicks. Do not miss the other tools: Backup and Restore wizards, CSV import wizard, Shrink wizard, etc.

User friendly interface

• myLittleAdmin interface gives the possibility to create and manage your own skins and language packages.
• myLittleAdmin is provided with several language packages: English, French, German and Japanese.

Platforms and integration

• Technology: .NET technology (C#)
• Platform: Windows 2000, 2003, 2008
• Web server: IIS 5, 6, 7
• Framework: Framework 2.0
• SQL server: MS SQL 2005 & 2008
• Misc.: CSS2, Javascript, XmlHttp, Ajax

Major Features:

1. Connection
   • SQL Server and Windows authentication
   • Network protocols and other options
2. Databases
   • System, Snapshot and User databases
   • List
   • Create, delete, rename
   • Properties, Permissions, Extended Properties
3. Tables
   • System and User tables
   • List
   • Create, delete, rename, modify
   • View dependencies
   • Quick data edit
   • Quick data filter
   • Export data to XLS, XML, CSV
   • Properties, Permissions, Extended Properties
4. Columns
   • List
   • Create, delete, rename, modify
   • Properties, Extended Properties
5. Keys
   • Foreign and primary keys List
   • Create, delete, rename, modify
6. Constraints
   • List
   • Create, delete, rename
   • Properties, Extended Properties
7. Triggers
   • List
   • Create, delete, rename, modify
   • View dependencies
   • Extended Properties
8. Indexes
   • List
   • Create, delete, rename
   • Properties, Extended Properties
9. Statistics
   • List
   • Create, delete
   • Properties
10. Views
    • System and User views
    • List
    • Create, delete, rename, modify
    • View dependencies
    • Quick data filter
    • Export data to XLS, XML, CSV
    • Properties, Permissions, Extended Properties
    • Columns, Triggers, Indexes, Statistics
11. Synonyms
    • List
    • Create, delete
    • Properties, Permissions, Extended Properties
12. Stored Procedures
    • System and User stored procedures
    • List
    • Create, delete, rename, modify
    • View dependencies
    • Properties, Permissions, Extended Properties
    • Parameters list
13. Functions
    • System and User table-valued functions
    • System and User scalar-valued functions
    • List
    • Create, delete, rename, modify
    • View dependencies
    • Properties, Permissions, Extended Properties
    • Parameters list
14. Database Triggers
    • List
    • Create, delete, modify
    • Extended Properties
15. Assemblies
    • List
    • Delete
16. Types
    • System data types, User-defined data types, User-defined types, XML schema collections
    • List
    • Create, delete, rename, modify
    • View dependencies
    • Properties, Extended Properties
17. Rules
    • List
    • Create, delete
    • View dependencies
    • Properties, Extended Properties
18. Defaults
    • List
    • Create, delete
    • View dependencies
    • Properties, Extended Properties
19. Service Broker
    • Message types, Contracts, Queues, Services, Routes, Remote Service Binding
    • List
    • Delete
20. Storage
    • Full Text Catalog, Partition Schemes, Partition Functions
    • List
    • Create, Modify, Delete
21. Users
    • List
    • Create, Rename, Delete
    • Properties, Extended Properties
22. Roles
    • Database roles, Application roles
    • List
    • Create, Rename, Delete
    • Properties
23. Schemas
    • Database roles, Application roles
    • List
    • Create, Delete, Modify
    • Properties, Permissions, Extended Properties
24. Symetric and Asymetric Keys
    • List
    • Delete
    • Properties
25. Certificates
    • List
    • Delete
    • Properties
26. Logins
    • List
    • Create, Delete, Modify
    • Properties
27. Server roles
    • List
    • Properties
28. Credentials
    • List
    • Delete
    • Properties
29. Backup devices
    • List
    • Create, Delete
    • Properties
30. Linked servers
    • List
    • Delete
    • Properties
31. Server Triggers
    • List
    • Create, Delete, Modify
32. Error log
    • List
33. Activity monitor
    • Process List
34. Tools and wizards
    • New query tool
    • Generate INSERT script wizard
    • CSV Import wizard
    • Backup wizard
    • Restore wizard
    • Detach wizard
    • Attach wizard
    • Shrink database wizard
    • Change password wizard
35. Preferences
    • Multi language
    • Multi skin
36. Misc.
    • Ability to enable/disable each feature
    • Ability to get the T-SQL script of each action
    • Silent logon module
    • and much more!

• Several enhancements, including permission management, extended properties etc.