SQL Server Performance

XP_readerrorlog or sp_readerrorlog in SQL 2000

Discussion in 'General DBA Questions' started by pchee373, May 5, 2009.

  1. pchee373 New Member

    I know that the SP is undocumented. I'm trying to run this SP at startup to look at the last log and insert it into a table. I can run the SP at start up in SQL 2005, but for some reason it's not working in SQL 2000. Does anyone else use this SP at startup?
    Thanks
    Paul Chee
    ITPRO1
    pchee373, May 5, 2009
    #2

  2. MohammedU New Member

    I don't think it can work in startup procedure...
    Best way to create the job and schedule it to run whenever SQL Agent starts...
    MohammedU, May 6, 2009
    #3

  3. satya Moderator

    What kind of error you are getting in SQL 2000?
    Why do you want to run this during the startup?
    satya, May 7, 2009
    #4

Share This Page