Ok, finding the time that it was occurring may have helped us figure it out. We'll see tomorrow morning, but it appears that it was an old scheduled task syncing...

Ok, got into the trace file. I found a few lines in there pertaining to the database in question. These lines appeared at 5:00 this morning and only for this...

Yes, that worked. There are only about 8 jobs in there, so not much to find, but they all came up.

I tried running it with the "alter database" in upper/lower, as well as all lower and still nothing.

I tried opening the most recent trace file, but it gives me a "failed to open - access is denied" notice and won't open it. I tried opening it both...

Ah, sorry, I was in the problem db. Ran fine in msdb. It found nothing. Anything else I might try?

When I run this I get the following error:

Msg 208, Level 16, State 1, Line 1

Invalid object name 'dbo.sysjobs'.

Sorry, I feel like a complete novice, but how do I check to see if there's an ALTER DATABASE statement being run on the db thru a job?

Thanks!

I am currently having this issue with one of my databases. It is the only one of 25 dbs that is doing this and I can't figure out what would...