Three options were presented for that.

You can check the create date of Tempdb as suggested in the script from Alz

You can check sql error logs

or

You can check Windows Event Log....

bitbucket-25253 (2/15/2010)

---

Jason

And Steve was off today on a ski trip ... but he did manage to add to the question "SQL Server 2000". but said nothing...

It could be an indicator of insufficient permissions.

Hopefully you are able to retrieve results. If you can get results, then you have an alternative method to get your perf...

Thanks Steve.

Yeah - kind of archaic I know. More of a precaution for me though. I like to be alerted when that drive...

Within the query as is - I can't either. However, I was thinking something more along the lines of dumping that data into a temp table and then using...

Being "average" sometimes might just be a matter of circumstance or lack of enjoyment in the job. I venture to say that sometimes time plays an important factor on...

All i have to say about the SPs is woohoo.

And I am yet another one of the many in the work queue today.

I agree with Elliott.

Here is a link on how to do that

http://www.codeproject.com/KB/database/foreachadossis.aspx

I find it interesting that the question has only been answered correctly 10% of the time. And 70% of the people missing the question all missed it selecting the...

You may consider using a combination of substring, left and right string functions.

http://msdn.microsoft.com/en-us/library/ms181984.aspx

This article is more specific to the task at hand.

http://www.codeproject.com/KB/database/foreachadossis.aspx

That is one option.

I would add...

Here is an article that performs a similar task

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/

This is to give you an idea of how to create an ssis package that can query each DB server.