Using dbcc upgrade_object

The following topics cover syntax, parameters, permissions, Increasing the log segment, error reporting and examples for using the dbcc upgrade_object.

• Syntax for Using dbcc upgrade_object
  Learn the syntax for using dbcc upgrade_object here.
• Parameters
  Learn about parameters here.
• Permissions
  Learn about permissions here.
• Increasing the Log Segment Size
  You can specify that all compiled objects of a particular class should be upgraded in one execution of dbcc upgrade_object; for example, you can upgrade all triggers by using the trigger keyword.
• Error reporting
  Learn about the error reporting function here.
• Examples
  Find examples for using dbcc upgrade_object.