myLittleAdmin Features

myLittleAdmin Features

Connection

  • SQL Server and Windows authentication
  • Network protocols and other options

Databases

  • System, Snapshot and User databases
  • List
  • Create, delete, rename
  • Properties, Permissions, Extended Properties

Tables

  • System and User tables
  • List
  • Create, delete, rename, modify
  • View dependencies
  • Quick data edit
  • Export data to XLS, XML, CSV
  • Properties, Permissions, Extended Properties

Columns

  • List
  • Create, delete, rename, modify
  • Properties, Extended Properties

Keys

  • Foreign and primary keys List
  • Create, delete, rename, modify

Constraints

  • List
  • Create, delete, rename
  • Properties, Extended Properties

Triggers

  • List
  • Create, delete, rename, modify
  • View dependencies
  • Extended Properties

Indexes

  • List
  • Create, delete, rename
  • Properties, Extended Properties

Statistics

  • List
  • Create, delete
  • Properties

Views

  • System and User views
  • List
  • Create, delete, rename, modify
  • View dependencies
  • Export data to XLS, XML, CSV
  • Properties, Permissions, Extended Properties
  • Columns, Triggers, Indexes, Statistics

Synonyms

  • List
  • Create, delete
  • Properties, Permissions, Extended Properties

Stored Procedures

  • System and User stored procedures
  • List
  • Create, delete, rename, modify
  • View dependencies
  • Properties, Permissions, Extended Properties
  • Parameters list

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

Database Triggers

  • List
  • Create, delete, modify
  • Extended Properties

Assemblies

  • List
  • Delete

Types

  • System data types, User-defined data types, User-defined types, XML schema collections
  • List
  • Create, delete, rename, modify
  • View dependencies
  • Properties, Extended Properties

Rules

  • List
  • Create, delete
  • View dependencies
  • Properties, Extended Properties

Defaults

  • List
  • Create, delete
  • View dependencies
  • Properties, Extended Properties

Service Broker

  • Message types, Contracts, Queues, Services, Routes, Remote Service Binding
  • List
  • Delete

Storage

  • Full Text Catalog, Partition Schemes, Partition Functions
  • List
  • Create, Modify, Delete

Users

  • List
  • Create, Rename, Delete
  • Properties, Extended Properties

Roles

  • Database roles, Application roles
  • List
  • Create, Rename, Delete
  • Properties

Schemas

  • Database roles, Application roles
  • List
  • Create, Delete, Modify
  • Properties, Permissions, Extended Properties

Symetric and Asymetric Keys

  • List
  • Delete
  • Properties

Certificates

  • List
  • Delete
  • Properties

Logins

  • List
  • Create, Delete, Modify
  • Properties

Server roles

  • List
  • Properties

Credentials

  • List
  • Delete
  • Properties

Backup devices

  • List
  • Create, Delete
  • Properties

Linked servers

  • List
  • Delete
  • Properties

Server Triggers

  • List
  • Create, Delete, Modify

Error log

  • List

Activity monitor

  • Process List

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

Preferences

  • Multi language
  • Multi skin

Misc

  • Ability to enable/disable each feature
  • Ability to get the T-SQL script of each action
  • Silent logon module
  • and much more!
 
 
 
 
 
 
For Home
For Business
For Hosters
For SaaS
For Developers
 
Desktop Computing
- Parallels Desktop
- Parallels Workstation
Server Virtualization
- Parallels Server
- Parallels Virtuozzo Containers
- Parallels Infrastructure Manager
Automation
- Parallels System Automation
- Parallels Business Automation
- Parallels Plesk Products
More Products