<div>
What do you mean by active?
</div>


<div>
To know if there has been any activity in DB level in last 60 days, so that we determine how many dB's are being actually used.
</div>


To know if there has been any activity in DB level in last 60 days, so that we determine how many dB's are being actually used.

<div>
In that case, based on the last mdf modified date, can we assume that the db is in use?<br />
<br />
Please advise.
</div>


In that case, based on the last mdf modified date, can we assume that the db is in use?

Please advise.

<div>
So what's the solution? Do you think, by changing the mode to Single User and generate call to Service Desk is the way to find out?<br />
<br />
Please advise.
</div>


So what's the solution? Do you think, by changing the mode to Single User and generate call to Service Desk is the way to find out?

Please advise.

<div>
You could set the db(s) OFFLINE and see if any errors are generated.<br />
<br />
You could run a trace that captures database names for all SQL procs and queries.
</div>


You could set the db(s) OFFLINE and see if any errors are generated.

You could run a trace that captures database names for all SQL procs and queries.

<div>
How to run a trace using SQL profiler that captures all the transactions for all the databases in the instance.
</div>


How to run a trace using SQL profiler that captures all the transactions for all the databases in the instance.

<div>
<div class="content wysiwyg-content">
Hello there,<br />
<br />
Please advise TSQL script to identify which DB's are active in last 60 days, in SQL server 2005 instance?<br />
<br />
Thanks and Regards
</div>
</div>


Hello there,

Please advise TSQL script to identify which DB's are active in last 60 days, in SQL server 2005 instance?

Thanks and Regards

TSQL script to identify which DB's are active in last 60 days, in SQL server 2005 instance

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.