Home Forums SQL Server 2005 Administering can you please write some messages with this string "Timeout Expired" to sqlagent log RE: can you please write some messages with this string "Timeout Expired" to sqlagent log

  • Find yourself a long query. Change the connection timeout properties of your DEV server so that it will force a time out. Create your alert. Run your query. That should test your alert.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.