SALES: 1-800-867-1380
This topic has not yet been rated - Rate this topic

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 Microsoft Azure SQL Database.

Microsoft 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.