Lester, have you had a look through the script library on this site. There is a good chance that a script like this has already been written.

Also, just a tip,...

Probably best option would be a .Net File Watcher service.

Within SQL you could setup a little VBScript to run in a SQL Agent job to check the Date Modified...

@Lester - how does this script solve the problem?

@Jon - are there any additonal error messages in the SQL Server Error log? Windows Application Event Log?

Jwalant, please start a new thread to post your problems instead of resurrecting threads that are over two years old.

Quite apart from the fact that waits and locks are two...

Have you run a trace at that time to see whats happening on the server?

Only thing that will happen is that the database won't automatically close when there are no connections.

You might actually find that applications using those databases are more responsive when they...

Well that's pretty clear, the three databases missing from the sqlperf output are set to autoclose and they're shutdown.

You'll need to connect to those databases to "wake" them.

I dug this old script up which shows the status from sysdatabases,

select

name as [DB_NAME]

, isnull(case when status & 1 = 1 then 'autoclose' else null end + ',',...

Yes it did output all databases and showed two as OFFLINE.

Anyone used dbcc sqlperf(logspace) command? is there a bug in it? The reason is that i have 15 databases (including master,model etc..) but everytime i use this dbcc command...

Rick, so were you able to sort out the old versions?

I've had my Dell 9400 laptop for eight months now. For the first three months it was running Windows XP and since then its been running Vista Ultimate and Office...

Doesn't seem that complex at all. Unless we're missing something.

Peter's response was just on my time conversion. So in my solution you can use style 108 instead of 114.

eg:

select convert(varchar(8), dateadd(second,@sec,0), 108) as WithHour

select right(convert(varchar(8), dateadd(second,@sec,0), 108), 5) as...

Actually to be precise { and } are braces, [ and ] are brackets and ( and ) are parentheses.