STOP SERVER [ database-server-name ] [ UNCONDITIONALLY ]

You can only use database-server-name in Interactive SQL only. If you do not execute this statement from Interactive SQL, the current database server is stopped.

By default, the database server is not stopped if there are other connections to it. If the UNCONDITIONALLY clause is used, the database server is stopped even if there are other connections to the database server. If the STOP SERVER statement is executed on a client connection and the server successfully shuts down, a communication error occurs.

The STOP SERVER statement cannot be used in stored procedures, triggers, events, or batches.

STOP ENGINE is accepted for compatibility reasons, but is deprecated.

Anyone can shut down the personal server (dbeng16).

The privileges to shut down a network server (dbsrv16) depend on the -gk setting on the database server command line. By default, the SERVER OPERATOR privilege is required to shut down a network server.

None

• START SERVER statement [Interactive SQL]
• -gk database server option

Stop the current database server, as long as there are no other connections.

STOP SERVER;