Thanks Paul, I appreciate it. I'm still exploring on my side too.

After some more digging this morning, System Views leads me back to Compatibility Views again, which in turn leads me back again to sys.sysprocesses. I ran SELECT * FROM sys.sysprocesses...

Have you run something like memtest86+[/url] (Free and open source) to rule out hardware faults?

Edit: Why are links not underlined by default?

Thanks Paul. I did some reading and SELECT * FROMing and saw that sys.dm_exec_requests gave me a database_id, but only for currently executing statements.

I need to show that at 13:00:42...

Thanks Paul. Which DMVs can I use that I can join with sys.dm_exec_connections abnd sys.dm_exec_sessions so that I can get a database name/id?

Currently, my query is

SELECT

ec.session_id...

Perhaps you should note in your article that the first script that you posted, the one that shows "TimesAccessed", only shows the data since the last restart of the SQL...

It's "lose data."

Nice article, thanks. I'll remember [font="Courier New"]RESTORE DATABASE WITH RECOVERY[/font]

Thanks Gail. The DBCC CHECKDB reported no errors.

We got tired of waiting for the vendor and decided to risk it. After unsuccessfully trying to replicate the error on an unnetworked...

Thanks Jack. SQL Server is running under the built-in account of Local System and the network share does have the correct permissions (other parts of the program work fine.)

It turns...

Thanks Thomas, but we can't change the code. Well, I suppose there is a possibility of doing that since we're working on a copy of the real database and it's...

As a DBA-by-Accident, having one tool that has almost everything that I need in it is a pleasure to work with. SSMS has that, and what it doesn't have inside,...

Thanks Mauve. That's what I thought, but I wasn't 100% sure.

Thank you for that sympathy! 🙂 In a similar manner I would...

Not necessarily.

Thanks Gail.