QOD 2003-10-23

• mcudmore

  SSC-Addicted

  Points: 495

  More actions

  October 23, 2003 at 1:51 pm

  #107220

  A more correct answer to this would be to use fn_get_sql introduced in SP3 for SQL Server 2000. DBCC INPUTBUFFER will only show the first 255 characters of the SQL in the buffer.

  Sincerely,

  Mark Cudmore, MCP... On my way to MCDBA

  
  Sincerely,
  
  Mark Cudmore, MCDBA

• Keith Henry

  Hall of Fame

  Points: 3759

  More actions

  October 24, 2003 at 7:34 am

  #479461

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17530&FORUM_ID=61&CAT_ID=5&Topic_Title=Question+of+the+day+2+cent&Forum_Title=Anything+that+is+NOT+about+SQL%21

  JordanAC pointed out the same thing. I need to stay up to date more

  Keith Henry

  DBA/Developer/BI Manager

  
  
  
  Keith Henry
  

  ---

  
  According to everyone I know I "do something with computers?" for a living, so there you go.