API system stored procedures Related content Applies to: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics SQL analytics endpoint in Microsoft Fabric Wareho
API system stored proceduresUsers that run SQL Server Profiler against ADO, OLE DB, and ODBC applications might notice these applications using system stored procedures that aren't covered in the Transact-SQL Reference. These stored procedures are used by the SQL Server Native Client OLE DB ...
In SQL Server, many administrative and informational activities can be performed by using system stored procedures. The system stored procedures are grouped into the categories shown in the following table. In this section Expand table CategoryDescription ...
System stored procedures This document contains information on undocumented stored procedures in Microsoft SQL Server. Name Function sp_cursor U
SQL Server Native Client ODBC driver to implement the functionality of a database API. These stored procedures are just the mechanism the provider or driver uses to communicate user requests to an instance of SQL Server. They are intended only for the internal use of the provider or the ...
系統存儲過程-System stored procedures System stored procedures This document contains information on undocumented stored procedures in Microsoft SQL Server. sp_cursoropen Defines the attributes of an API server cursor, such as its scrolling behavior and the statement used to build the result set on ...
System Stored Procedures (System) (Level 1)** New Information - SQL Server 2000 SP3.**SQL Server 6.xSQL Server 2000 Several system stored procedures were used for documenting keys. Removed; no longer supported or available. Use declarative referential integrity by implementing keys and constraints...
Sites may not be able to upgrade to a new version of SQL Server until they have rewritten applications that are selecting from system tables. SQL Server considers the system stored procedures, DDL, and SQL-SMO published interfaces, and works to maintain the backward compatibility of these ...
Stored procedures Tables Compare change tracking with CDC Triggers User-defined functions Views XML data Vectors in the SQL Database Engine Development Internals & architecture Installation Migrate & load data Manage, monitor, & tune Query data ...
Another question is it if you really need to create a system object for what you want to achieve. Apart from the case in the KB which was about system object for replication which were created wrongly, I used it a couple of times for procedures which I want to call from any database,...