Professional Web Applications Themes

DBCC Question - Microsoft SQL / MS SQL Server

I want to write a delete trigger to output to a log table but I want to include the text of the query i.e. DECLARE spid INT SELECT spid = spid DBCC INPUTBUFFER(spid) Does anyone know a way to save the output of a DBCC command to a file/table/variable Thanks in advance !...

  1. #1

    Default DBCC Question

    I want to write a delete trigger to output to a log table
    but I want to include the text of the query i.e.

    DECLARE spid INT
    SELECT spid = spid
    DBCC INPUTBUFFER(spid)

    Does anyone know a way to save the output of a DBCC
    command to a file/table/variable

    Thanks in advance !
    Andrew Guest

  2. #2

    Default Re: DBCC Question


    Look this script:

    DECLARE spid VARCHAR(10)
    SELECT spid = spid

    CREATE #temp (eventype VARCHAR(1000),parameters INT,eventinfo
    VARCHAR(2000))
    INSERT INTO#temp EXEC('DBCC INPUTBUFFER(' +spid + ')')

    SELECT * FROM #temp
    DROP TABLE #temp


    --
    --

    Un saludo

    --
    --
    ----------------------------------------------
    "Sólo sé que no sé nada. " (Sócrates)

    Por favor, responder únicamente al foro

    (Guía de netiquette del foro)
    [url]http://www.helpdna.net/bosqlfaq00.htm[/url]
    [url]http://perso.wanadoo.es/rubenvigon/foro[/url]

    (FAQ's de SQL Server)
    [url]http://support.microsoft.com/default.aspx?scid=/support/sql/70faq.asp[/url]
    [url]http://www.helpdna.net/bosqlfaq.htm[/url]

    "Andrew" <andrew_m_bakerhotmail.com> escribió en el mensaje
    news:042301c346c9$5bf6af10$a001280aphx.gbl...
    > I want to write a delete trigger to output to a log table
    > but I want to include the text of the query i.e.
    >
    > DECLARE spid INT
    > SELECT spid = spid
    > DBCC INPUTBUFFER(spid)
    >
    > Does anyone know a way to save the output of a DBCC
    > command to a file/table/variable
    >
    > Thanks in advance !

    Carlos Sacristan Guest

Similar Threads

  1. Newbie Question: Biz Card Template Question
    By Thomas_Porter@adobeforums.com in forum Adobe Indesign Windows
    Replies: 4
    Last Post: May 30th, 08:08 AM
  2. Replies: 9
    Last Post: April 27th, 04:44 AM
  3. Pen Tool Use Question. (Embarrassingly Newbie Question)
    By Bozo Schmozo in forum Macromedia Flash
    Replies: 0
    Last Post: November 12th, 10:00 PM
  4. Global variable question question
    By Jason Giangrande in forum PHP Development
    Replies: 3
    Last Post: July 23rd, 08:27 PM
  5. newB question: related tables question
    By Blue man in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: June 30th, 04:13 AM

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