Removes one or more stored procedures or procedure groups from the current database in SQL Server.Transact-SQL syntax conventionsSyntaxsyntaxsql კოპირება -- Syntax for SQL Server and Az
sys.parameters (Transact-SQL) Altre risorse Eliminazione di stored procedure Procedura: Eliminazione di una stored procedure (SQL Server Management Studio) Guida in linea e informazioni Assistenza su SQL Server 2005
Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) Warehouse in Microsoft Fabric Removes one or more table definitions and all data, indexes, triggers, constraints, and permission specifications for those tables. Any view or stored procedure that references the dropped ...
When you specify extended properties, the objects in a SQL Server database are classified into three levels: 0, 1, and 2. Level 0 is the highest level and is defined as objects contained at the database scope. Level 1 objects are contained in a schema or user scope, and level...
In this article Syntax Arguments Return code values Remarks Show 2 more Applies to: SQL Server Removes an alternate Publisher from a merge publication. This stored procedure is executed at the Subscriber on the subscription database. Transact-SQL syntax c...
Requires membership in thesysadminfixed server role, or execute permission directly on this stored procedure. Examples The following example drops the retention period setting of theAdventureWorks2022database. SQL EXEC sp_dbmmonitordropalert AdventureWorks2022, 5; ...
SqlVerifyAction Statistic StatisticCollection StatisticColumn StatisticColumnCollection StatisticEvents StatisticsScanType StatisticsTarget StopListOption StoredProcedure StoredProcedureCollection StoredProcedureEvent StoredProcedureEvents StoredProcedureEventSet StoredProcedureParameter StoredProcedureParameterCollection SuspectPa...
In Microsoft SQL Server 2008, you enable the change data capture (CDC) feature for a database. You drop the cdc.change_tables CDC system table. You run the sp_cdc_disable_db stored procedure to disable CDC. In this scen...
In Microsoft SQL Server 2008, you enable the change data capture (CDC) feature for a database. You drop the cdc.change_tables CDC system table. You run the sp_cdc_disable_db stored procedure to disable CDC. In this scenario, you may receive the following error message: ...
This stored procedure has been deprecated and is being supported mainly for backward-compatibility. It should only be used with SQL Server 2000 (8.x) Publishers and SQL Server 2000 (8.x) republishing Subscribers. This procedure shouldn't be used on columns with data types that ...