I'm not 100% sure, but I believe it works a file at a time, in other words, it has it's own queue of writes to move, so the pausing would...

Try looking at fn_my_permissions or query sys.database_permissions or sys.server_permissions.

Are you sure the job is done? Just because it's done on other mornings doesn't mean it's not a problem on that day.

Also, you aren't defragging the distribution database, you're...

You would need the format of the Appointment email and then build that in SQL Server. I don't know of a solution off hand for this.

Is it using Exchange?...

It's not any long running jobs, it's more that if a lot of data changes occur, the logs grow. If someone updated every row to some wrong value and then...

I work for Red Gate and I have heard great things about their tools.

However I think any of the tools will work and you can burn the $300 or so...

Please let us know if this is the case. Might help others or we can give you other suggestions. I think it's probably corrupt, but you never know.

What was the problem (for others)? Security?

No way to restrict things, but some things, like the Object Browser do not work against 2005.

I'd do as Michael suggested and leave him/her with QA.

If you've got programmers,...

Not really supported, but counting by database.

select count(s.spid)

, d.name d

from sys.sysprocesses s

inner join sys.databases d

on s.dbid = d.database_id

group by...

What are you trying to do? We might be able to help another way.

I agree with Noeld that you should try a reboot and see what happens. Maybe shut down some processes and windows on your system. If it happens again, I'd run...

I had something similar in SQL 2000. It had to do with the disk system not keeping up with the update load.

Have you checked to see if there are issues...

I think the extensions of SOX are what has caused the problems. Most regulatory agencies specifically target certain types of data. SOX went after everything.

Or at least the auditors did.

I haven't seen it, but my wife, Mom, karate instructor, and a few others loved it.

Good luck!