As much as I appreciate the suggestion and code, I should have stated I do not have the permission required to create a new table, nor make changes to an...

Thank you Luis....

Eric:

Thank you for the query, but this doesn't show me the procedure / job / etc that ran against the object, just the execution plan, correct?

Thank you for the suggestion, but unfortunately I am unable to install that product (despite making the argument it is helpful for exactly these types of situations). Our corporate...

Thank you for the reply.

Now my follow-up question. What will happen to reports created using Visual Studio 2008 and BIDS? Will they need to be upgraded...

I think I found the information you mention:

http://searchsqlserver.techtarget.com/tip/Manage-your-SQL-Server-databases-with-SQL-DMVs

http://www.codeproject.com/Articles/16861/Dynamic-Management-Views-DMV-A-SQL-Server-Fea

http://www.codeproject.com/Articles/16861/Dynamic-Management-Views-DMV-A-SQL-Server-Fea

I think some of these links provide the information you were talking about. I should be...

Thank you for the help, but a follow-up question....

1). In SSMS (SQL Server Management Studio), I do not have an option for Management -- Data Collection. I can't...

I found this on DMVs

https://msdn.microsoft.com/en-us/library/hh230820.aspx

But it looks like these are only available for SQL Server 2012 and later. We are still using SQL Server 2008 R2. ...

Thank you for the help. Out of curiosity: does that "evaluation" copy have to be the same version we are using (SQL Server 2008 R2), or can it...

Thank you for the suggestion, but I do not have a copy of the medium used. It was installed by our corporate software team prior to me getting the...