0

In SQL Server Management Studio, I have a bunch of temporary tables, they look like they were created by the system:

enter image description here

Can I drop them? How can I get more information about them? For example, what procedures are creating these? I'd like to fix what is causing this.

Thanks!

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Joth
  • 155
  • 1
  • 2
  • 10
  • No worries, these will auto delete when procedure call ends. – Yogesh Sharma Nov 28 '18 at 17:24
  • Yes, thanks, but these tables were created several hours ago. Does that mean a procedure has crashed? None of the procedures should really run more than a minute or two. – Joth Nov 28 '18 at 17:31
  • 1
    Depending on how they're created, it might require that the connections they were created on get disconnected. – squillman Nov 28 '18 at 17:37

0 Answers0