Strange Event in the Activity Log

  • Hi,

    I've got a strange message in the activity log of my SQL 2000 Server (SP4). At 45 mins past the hour, every hour, the following gets posted:

    SPID XXX - Starting up database ' '

    I have no database on my server with that name, any ideas where this is coming from and how I can stop it?

    Cheers,

    Jon............

  • There are no databases that have Autoclose set?

    Very strange. Have you tried Profiling around that time, looking for something strange?

    Can you DBCC INPUTBUFFER the SPID when that occurs?

  • Thanks Steve, pointed me in the right direction !

    Just off to book my next opticians appointment 😉

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply