Eksportér (0) Udskriv
Udvid alt
EN
Dette indhold er ikke tilgængeligt på dit sprog, men her er den engelske version.
Dette emne er endnu ikke blevet bedømt - Bedøm dette emne

sp_refreshsqlmodule (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see sp_refreshsqlmodule.

Updates the metadata for the specified non-schema-bound stored procedure, user-defined function, view, data manipulation language (DML) trigger, or database-level data definition language (DDL) trigger in the current database.

Syntax Conventions (Azure SQL Database)

sys.sp_refreshsqlmodule [ @name= ] 'module_name' 
    [ , [ @namespace = ] ' <class> ' ]

<class> ::=
{
  | DATABASE_DDL_TRIGGER
}

This syntax diagram demonstrates the supported arguments and options in Microsoft Windows Azure SQL Database.

Windows Azure SQL Database does not support the @namespace = SERVER_DDL_TRIGGER option with the sp_refreshsqlmodule system stored procedure.

For more information about the arguments and the sp_refreshsqlmodule system stored procedure, see sp_refreshsqlmodule in SQL Server Books Online.

Requires ALTER ANY DATABASE DDL TRIGGER permission in the current database when the specified module is a database-level DDL trigger.

Syntes du, dette var nyttigt?
(1500 tegn tilbage)
Tak for din feedback

Fællesskabsindhold

Tilføj
Vis:
© 2014 Microsoft. Alle rettigheder forbeholdes.