Post reply

Strange Event in the Activity Log

  • July 2, 2008 at 9:54 am

    #72345

    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............

  • July 2, 2008 at 10:07 am

    #837323

    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?

  • July 3, 2008 at 8:31 am

    #837897

    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