Professional Web Applications Themes

Viewing the event log - Microsoft SQL / MS SQL Server

I turned on trace flag 1204 and forced a deadlock on our test server. When I try to view the output in the event log in the Enterprise Manager, double clicking on the message brings up in a window with next and previous buttons and I have click through multiple lines of output. This is REALLY annoying. Is there a better way to view the eventlog? Thanks, Bob Castleman SuccessWare Software...

  1. #1

    Default Viewing the event log

    I turned on trace flag 1204 and forced a deadlock on our test server. When I
    try to view the output in the event log in the Enterprise Manager, double
    clicking on the message brings up in a window with next and previous buttons
    and I have click through multiple lines of output.

    This is REALLY annoying. Is there a better way to view the eventlog?

    Thanks,

    Bob Castleman
    SuccessWare Software


    Bob Castleman Guest

  2. #2

    Default Re: Viewing the event log

    Consider opening the SQL Server error log with a text viewer like
    Notepad. The error log is in the Log subfolder of the SQL Server
    installation root folder.

    --
    Hope this helps.

    Dan Guzman
    SQL Server MVP

    -----------------------
    SQL FAQ links (courtesy Neil Pike):

    [url]http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800[/url]
    [url]http://www.sqlserverfaq.com[/url]
    [url]http://www.mssqlserver.com/faq[/url]
    -----------------------

    "Bob Castleman" <nomailhere> wrote in message
    news:%231efH7YRDHA.2128TK2MSFTNGP12.phx.gbl...
    > I turned on trace flag 1204 and forced a deadlock on our test server.
    When I
    > try to view the output in the event log in the Enterprise Manager,
    double
    > clicking on the message brings up in a window with next and previous
    buttons
    > and I have click through multiple lines of output.
    >
    > This is REALLY annoying. Is there a better way to view the eventlog?
    >
    > Thanks,
    >
    > Bob Castleman
    > SuccessWare Software
    >
    >

    Dan Guzman Guest

  3. #3

    Default Re: Viewing the event log

    Thanks.

    Did not know it was a text file.

    Bob

    "Dan Guzman" <danguzmannospam-earthlink.net> wrote in message
    news:eIN0VubRDHA.384TK2MSFTNGP12.phx.gbl...
    > Consider opening the SQL Server error log with a text viewer like
    > Notepad. The error log is in the Log subfolder of the SQL Server
    > installation root folder.
    >
    > --
    > Hope this helps.
    >
    > Dan Guzman
    > SQL Server MVP
    >
    > -----------------------
    > SQL FAQ links (courtesy Neil Pike):
    >
    > [url]http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800[/url]
    > [url]http://www.sqlserverfaq.com[/url]
    > [url]http://www.mssqlserver.com/faq[/url]
    > -----------------------
    >
    > "Bob Castleman" <nomailhere> wrote in message
    > news:%231efH7YRDHA.2128TK2MSFTNGP12.phx.gbl...
    > > I turned on trace flag 1204 and forced a deadlock on our test server.
    > When I
    > > try to view the output in the event log in the Enterprise Manager,
    > double
    > > clicking on the message brings up in a window with next and previous
    > buttons
    > > and I have click through multiple lines of output.
    > >
    > > This is REALLY annoying. Is there a better way to view the eventlog?
    > >
    > > Thanks,
    > >
    > > Bob Castleman
    > > SuccessWare Software
    > >
    > >
    >
    >

    Bob Castleman Guest

Similar Threads

  1. Getting Error: Event Type 'flash.event:event' is unavailable ?????
    By malik.robinson@gmail.com in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: January 14th, 01:51 AM
  2. stumped...table - row - click event, cancel checkbox event
    By dave in forum ASP.NET Building Controls
    Replies: 0
    Last Post: September 2nd, 01:28 AM
  3. Replies: 2
    Last Post: December 17th, 03:58 PM
  4. Replies: 0
    Last Post: April 5th, 02:26 PM
  5. Replies: 0
    Last Post: July 28th, 11:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139