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

database-server-name can be used in Interactive SQL only. If you are not running this statement in Interactive SQL, the current database server is stopped.

The STOP SERVER statement stops the specified database server. If the UNCONDITIONALLY keyword is supplied, the database server is stopped even if there are other connections to the database server. By default, the database server is not stopped if there are other connections to it.

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

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

The permissions to shut down a server depend on the -gk setting on the database server command line. The default setting is all for the personal server, and DBA for the network server.

None

• START SERVER statement [Interactive SQL]
• -gk dbeng12/dbsrv12 server option

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

STOP SERVER;