No.

Very nice article and great output. Just a suggestion

In your script, to caluculate uptime (for variable @vOnline_Since), it might be better to use 'tempdb' instead of 'perfstat' database in the...

Thanks for the post. It helped me to get database_id. I was struggling for this ebcause neither sys.dm_exec_connection or sys.dm_exec_sessions had this id and I had to run a report...

Interesting.. Will wait for the answer..

Good efforts. Adding some rebuild decision criteria eg. Physical fragmentation gone more that 10% or logical fragmentation gone more than 15% might have been better.

Even though I have not faced any corruption as of date, but now i am ready with at least some thought. Good one.

Thank you all. Issue resolved. Just the restart of SQL Server Agent Service worked.

Seems that Agent log file was either locked or corrupted. Each time the stored procedure...

Yes the account name that runs is 'SA'. This is SQL Server 2005 with SP2.

Thanks!! I think this may be a good solution to it. Will try not sure if that will be feasible for all to follow. But I will try my best..

Scott,

I work in an environment where my team is supporting almost 500 server with all sorts of environment(DEV/UAT/SIT/PROD/DR). These systems are being used by multiple applications, which often requires database...

The new user has to be created after any of the below mentioned operation happens.

1. If a new database has been created

OR

2. If a any database has been retored.

Thanks again. Your explanation will work as a good guideline for me to for further investigation.

Thanks for the suggestion. 🙂 Your answer hit the bull eye.

However I could not get the query from Application team.

DBCC FREEPROCCACHE resolved the issue for the time being.

Could you...