Results 1 to 3 of 3

Thread: Current SQL Statement

  1. 09-25-2001, 03:27 PM #1
    Mike Guest

    Current SQL Statement

    My backup fails in the night, because of a non logged operation being executed at the same instant. I am interested in finding out the statement that is causing the problem. What would be the best way to do that?

    Reply With Quote Reply With Quote
  2. 09-25-2001, 03:52 PM #2
    Ray Miao Guest

    Current SQL Statement (reply)

    Try 'dbcc inputbuffer'.


    ------------
    Mike at 9/25/01 4:27:42 PM

    My backup fails in the night, because of a non logged operation being executed at the same instant. I am interested in finding out the statement that is causing the problem. What would be the best way to do that?

    Reply With Quote Reply With Quote
  3. 09-26-2001, 10:52 AM #3
    Mike Guest

    Current SQL Statement (reply)


    Thanks Ray. I found that dbcc inputbuffer, gives only 255 char, is there a way we can view the entire statement.

    thanks

    ------------
    Ray Miao at 9/25/01 4:52:05 PM

    Try 'dbcc inputbuffer'.


    ------------
    Mike at 9/25/01 4:27:42 PM

    My backup fails in the night, because of a non logged operation being executed at the same instant. I am interested in finding out the statement that is causing the problem. What would be the best way to do that?

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules