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

---

Created June 23, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com