How can I see how many objects are actually open in SQL Server?

A. On SQL 6.5 you can use the dbcc des command. This will list entries per open object.

dbcc traceon(3604)
go
dbcc des
go


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