I'm not seeing anything in the current activity screen in SQL EM.

A. A. This is usually caused by the "select into/bulkcopy" database attribute for tempdb being unchecked.

Set the option on again using SQL EM or sp_dboption and that should fix it.


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish