en / fr

myLittleAdmin for SQL Server 2000

Features

Platforms and integration
TechnologyActive Server Page (ASP)
PlatformWindows NT/2000
Web serverIIS 5
LanguageVBScript (Script engine v5.5 or further is required)
SQL serverMS SQL 7, MS SQL 2000, MSDE
Dll or componentsSQL script generation feature requires SQLDMO to be installed or this feature won't be available
Space used graph requires the client to have a SVG viewer installed. (a viewer can freely download on Adobe website : http://www.adobe.com/svg/viewer/install/main.html)
Other requirementsMDAC 2.5

 

FeaturesFree Lite versionWebHosting EditionFull version *
Connection
DSN-less and DSN connection   
Windows and SQL server authentication   
Trusted connection   
User levels   
Databases
List   
Create, delete, rename, generate SQL script   
Display space used   
BackUp   
Detach   
Shrink   
Add, delete, modify extended properties   
Tables
List   
Data search   
Quick data edit   
Create, delete, rename, generate SQL script   
Export data to character-delimited files or XML files    
Export data to XLS files    
Add, delete, modify extended properties   
Columns
List   
Create, delete, rename, edit    
Add, delete, modify extended properties   
Indexes
List   
Create, delete, rename, generate SQL script   
Rebuild   
Add, delete, modify extended properties   
Relationships (Foreign Keys)
List   
Create, delete, rename, generate SQL script   
Add, delete, modify extended properties   
Triggers
List   
View T-SQL   
Create, delete, rename, edit, generate SQL script   
Add, delete, modify extended properties   
Constraints (Checks)
List   
Create, delete, rename, edit, generate SQL script   
Add, delete, modify extended properties   
Views
List   
View T-SQL   
Data search    
Create, delete, rename, edit, generate SQL script   
Export data to character-delimited files or XML files    
Export data to XLS files    
Add, delete, modify extended properties   
Stored procedures
List   
View T-SQL   
Create, delete, rename, edit, generate SQL script   
Add, delete, modify extended properties   
Users
List   
Create, delete, edit, generate SQL script   
Add, delete, modify extended properties   
Roles
List   
Create, delete, generate SQL script   
Rules
List   
Create, delete, rename, generate SQL script   
Link to UDT and columns   
Add, delete, modify extended properties   
Defaults
List   
Create, delete, rename, generate SQL script   
Link to UDT and columns   
Add, delete, modify extended properties   
User defined types (UDT)
List   
Create, delete, rename, edit, generate SQL script   
Add, delete, modify extended properties   
User defined functions (UDF)
List   
View T-SQL   
Create, delete, rename, edit, generate SQL script   
Add, delete, modify extended properties   
Management - BackUp Devices
List   
Create, delete, rename, edit   
Management - Activity
Process info   
Locks / process id   
Locks / objects   
Kill process   
Error Log
Display current and archived error logs   
Logins
List   
Create, delete, edit   
Manage password   
Server roles
List   
Tools
Query analyser   
Generate INSERT scripts   
CSV Import wizard   
BackUp wizard   
Restore wizard   
Attach database   
Shrink wizard   
Change password   
Options
Multi languages   
Multi skins   
Show/hide system objects   
* Full version is for both "Single" license and "Unlimited Use" license.