ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-18
System Procedures
sp_changedbowner Must be done with Guardian permissions. You can alter file
permissions in NonStop SQL/MP using the ALTER TABLE or
SECURE statements.
sp_commonkey None
sp_configure You can configure all tables or specific tables in NonStop SQL/MP
using the CONTROL TABLE statement.
sp_dboption None
sp_defaultdb You can establish a default database by using the ADDNAME USER
statement; otherwise, the default database is always MASTER.
sp_depends You can select against the USAGES table in NonStop SQL/MP.
sp_diskdefault None
sp_dropalias You can drop alias usernames with the DELETENAME ALIAS
statement.
sp_dropdevice None
sp_dropgroup None
sp_dropkey None. You cannot remove a key.
sp_droplogin Must be done by a Guardian administrator
sp_droptype None
sp_dropuser You can drop usernames with the DELETENAME USER statement.
sp_foreignkey None
sp_help Use INVOKE to view column names.
Use Guardian statements to view file information such as owner,
permissions, and last modification.
To determine the uses of an object, select against the NonStop
SQL/MP catalog tables using the NonStop SQL/MP DISPLAY USE
OF utility statement.
sp_helpdb To determine the uses of a database, select against the NonStop
SQL/MP catalog tables using the NonStop SQL/MP DISPLAY USE
OF utility statement.
sp_helpdevice None. Devices are not supported.
sp_helpgroup None. Groups are not supported and are not available in NonStop
SQL/MP.
sp_helpindex To determine the uses of an index, select against the NonStop
SQL/MP catalog tables using the NonStop SQL/MP DISPLAY USE
OF utility statement.
sp_helpjoins None
sp_helpkey None
Table B-6. SQL Server System Procedures (page 2 of 3)
System Procedure
Alternatives Available Using NonStop SQL/MP or the HP
NonStop Kernel Operating System