Restrictions for show_sqltext

Restrictions for using show_sqltext.

  • You must have the sa or sso roles to run show_sqltext.

  • You cannot use show_sqltext to print the SQL text for triggers.

  • You cannot use show_sqltext to show a binding variable or a view name.