Choose your SQL server:

Customers

Become a customer

Testimonials

DavidNR:
"MS SQL Maestro is a great app. Loved it. I only used it for its blob support thus far, very nice and very fast".

Kevin Settler:
"If you need the job done right and on time, do it with MS SQL Maestro on your team. The software is a pleasure for us. SQL Maestro Group do excellent work and are dedicated to producing products that all can be proud of".

Paolo Benjamin T. Briones:
"I just downloaded the trial and its great! IMHO, its a lot better than the Enterprise Manager from SQL Server".

Albert Rognan:
"Thank you for this quick reply. I must say I am impressed of the number of functions that is available within this tool".

Add your opinion

SQL Maestro Group / Products / MS SQL Server / MS SQL Maestro / Documentation

Download Buy

MS SQL Maestro online Help

Return to chapter overview

Server Roles Editor

Server Roles Editor allows you to view the logins implemented to the role, include or exclude existing logins from the definite role.

Note: Members of the securityadmin fixed server role can grant both server-level and database-level permissions.

The Name and Comment fields represents the server role name and comment respectively.

Logins

Displays the list of all existing logins. If a login name is checked, the login is added to the fixed server role.

To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl+F9 or Ctrl+F7 shortcut keys.

It is also possible to modify object properties without opening the object editor: use the Object Properties item of the popup menu of the selected object from the explorer tree.

Return to chapter overview

New Year Sale!

SQL Maestro Group team wishes you a Happy New Year 2009!

We're glad to grant you a 20% discount for all our products and bundles till January 11!
The offer expires in day(s), so don't wait: act now and start the New Year with great savings on high-quality DBA tools!

Company news

Nov 1, 2008

MS SQL Maestro 8.11 released

Introduces a new Dependency Tracker tool, support for some SQL Server 2008 new features, and a lot of interface improvements.

Jan 8, 2008

MS SQL Maestro 8.1 released

Extended property management, SQL server logs analysis and some other features.

Oct 16, 2007

MS SQL Maestro 7.10 released

Features a new Backup Database tool, Attach and Detach Database Wizards, cancellation of long-running queries, SQL Formatter for DML statements and more.

More news

Feature of the day

Data Export

MS SQL Maestro allows you to export data to any of 14 available data formats.

Object Duplicating

MS SQL Maestro allows you to make a copy of a database object by dragging it from one database to another.