DBCC Commands

• brk5tr

  Ten Centuries

  Points: 1300

  More actions

  October 1, 2010 at 5:38 pm

  #157235

  Hi

  I am using [DBCC IND] to return information related to my database pages. Is it possible to use this data in other statements?

  E.g.

  My current statement is:

  DBCC IND (DatabaseName, TableName, 3);

  There is no 'SELECT' syntax there, so how could I filter the returned columns etc? Also, how can I use the results? For example, if I wanted to insert the results into a temp table?

  Thanks for any information.

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  October 1, 2010 at 8:26 pm

  #1230638

  ggjjbb1983

  From Books On Line - with some DBCC commands you can:

  CREATE TABLE #tracestatus (

  TraceFlag int,

  Status int,

  Global int,

  Session int

  )

  -- Execute the command, putting the results in the table.

  INSERT INTO #tracestatus

  EXEC ('DBCC TRACESTATUS (-1) WITH NO_INFOMSGS')

  -- Display the results.

  SELECT *

  FROM #tracestatus

  GO

  DROP TABLE #tracestatus

  Running the command twice produced the following results:

  TraceFlagStatusGlobalSession

  8017 1 1 0

  8017 1 1 0

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• brk5tr

  Ten Centuries

  Points: 1300

  More actions

  October 4, 2010 at 10:42 am

  #1231135

  Thats what I needed. Thanks.