Home

	Expand Search

Enterprise SQL Server Manager Reference Manual

About This Book

About This Book

Enterprise SQL Server Manager Reference Manual is a reference tool describing the basic syntax and usage information for every Enterprise SQL Server Manager^TM command. It also explains the Enterprise SQL Server Manager command line interface and its conventions.

Audience

This manual is for administrators who want to manipulate Sybase(R) SQL Server^TM database objects within the Tivoli Management Environment, either from the operating system command line or using scripts.

This manual is for experienced Enterprise SQL Server Manager administrators. It assumes you are familiar with SQL Server and database concepts and the procedures described in the Tivoli Management Platform Guide and the Enterprise SQL Server Manager User's Guide. You should read those books before using this manual.

How to Use This Book

Use this book as a reference tool for complete information on Enterprise SQL Server Manager command syntax and usage. This book consists of the following chapters:

• Chapter 1, "Introduction," gives an overview of the Enterprise SQL Server Manager command line interface and describes common command behavior and usage.
• Chapter 2, "Enterprise SQL Server Manager Commands," contains reference information on every Enterprise SQL Server Manager command. Commands appear in reference page format, listed alphabetically by name. There is also a summary of commands grouped by function at the beginning of the chapter.
• Appendix A, "Database Options," describes the SQL Server database options that Enterprise SQL Server Manager supports.
• The Glossary defines the special terms that appear in this book.

Related Documents

In addition to this document, the following manuals are part of the Enterprise SQL Server Manager documentation set:

• Enterprise SQL Server Manager Release Bulletin contains important release-specific information, including a list of known problems.
• Enterprise SQL Server Manager Installation and Planning Guide contains planning information and describes how to install Enterprise SQL Server Manager.
• Enterprise SQL Server Manager User's Guide is a guide to Enterprise SQL Server Manager and SQL Server systems management using Enterprise SQL Server Manager.
• Tivoli Management Platform Release Notes contain important release-specific information about the Tivoli Management Environment (TME) included with Enterprise SQL Server Manager.
• Tivoli Management Platform User's Guide is a comprehensive guide to the TME desktop.
• Tivoli Management Platform Reference Manual describes the TME command line interface.
• Tivoli/Sentry User's Guide describes the Tivoli/Sentry management application tool. Enterprise SQL Server Manager Event Monitoring (EMON) Services is based on the technology used by Tivoli/Sentry. The Tivoli/Sentry User's Guide provides information that will help you use EMON Services.

Other Documents

• Online help includes step-by-step instructions for every Enterprise SQL Server Manager procedure.
• System Administration Guide describes how to administer SQL Server and databases, independent of system administration tools such as Enterprise SQL Server Manager. It includes the Transact-SQL^TM commands and system procedures used to perform the functions for which Enterprise SQL Server Manager provides its own interface.
• SQL Server Reference Manual provides basic syntax and usage information for every command, function, system procedure, and catalog stored procedure.
• SQL Server Utility Programs documents SQL Server utility programs, such as bcp, that you execute from the operating system command line.
• Sybase Troubleshooting Guide contains information that helps you prevent or quickly respond to trouble with SQL Server. It includes topics such as how to determine appropriate settings of configuration variables, how to manage transaction logs, how to develop good recovery procedures, and how to use disk mirroring effectively.

Other Sources of Information

Sybase offers a system and database administration class called "SQL Server Administration." For details, contact:

Mail: Education Registrars
Sybase Professional Services
77 South Bedford Street
Burlington, MA 01803

Phone: (800) 8-SYBASE or (617) 564-6970

Fax: (800) 792-2733 or (617) 564-6960

E-mail: registrars@sybase.com

Notational Conventions

The following sections describe the style and syntax conventions used in this book.

Style Conventions

Syntax statements (displaying the syntax and all options for a command) appear as follows:

sunmanageserver -name server_name [-version] [-help]

or for a command with too many options to fit on one line, as:

sgetroleaudit [-types role_names] [-onlynames] 
[-list] [-server server_name] [-version] [-help]

The multiline syntax format is for clarity of presentation in this manual. When you enter a command, do not press the Enter key (or Return key, depending on your keyboard) until you finish typing the entire command.

Examples showing the use of Enterprise SQL Server Manager commands appear as follows:

sgetuser -database SMADA/pubs2

In this example, SMADA is the name of a SQL Server installation and pubs2 is the name of a database in SQL Server. If an example is prefaced with 1., 2., and so on, this is the example number.

If a command example takes several lines, some of which must be ended with a control key, the control key is indicated as follows:

scrtrule -name quiz_answer 
  -database PARIS_DEV/master <Return>
answer in ("A", "B", "C") <Return>
<CTRL-D>

Examples of output from Enterprise SQL Server Manager commands appear as follows:

*** Users In Database: SMADA/pubs2 ***
User        Login       Group     
----------  ----------  ----------
cat         cata        public    
cootie      cwilliams   public    
guest       null        public    
hjones      hjones      public    
mercer      mercere     public    
example%

Syntax Conventions

In this book, all command syntax statements use the following notational conventions:

Table 1: Enterprise SQL Server Manager command syntax conventions

Example	Description
scrtlogin	Command keywords appear in lowercase.
name	Variable arguments (words that stand for values that you supply in the command) appear in italic.
[-help]	Brackets mean that including the enclosed items in the command is optional. Do not include the brackets in your command.
{name [-wildcard]}	Braces mean that you must include one or more of the enclosed items. Do not include the braces in your command.
true | false	A vertical bar means that you can select only one of the two items that appear. Do not include the vertical bar in your command.
[, device size]...	Ellipses (...) indicate that you can repeat the preceding item as many times as you like in the command. Do not include the ellipsis in your command.

Include all other characters (commas, parentheses, and others) just as they appear in the command syntax statement.

If You Need Help

Help is available for the Enterprise SQL Server Manager user in the form of documentation, online help, online manual pages, and the Sybase Technical Support Center.

Technical Support

Each Sybase installation site has one person (or more) designated to contact the Technical Support Center. If you cannot solve a problem using the manuals or online help, ask the designated person at your site to contact the Technical Support Center for help.