DBCC Commands

• ashwin4all1

  Ten Centuries

  Points: 1131

  More actions

  February 16, 2010 at 3:20 am

  #220578

  Hi guys,

  is there any way to view the dbcc command program...??? i mean what is in side the dbcc command.

  and one more question . In sql 2000 we can read the VIEW Program by clicking the right pain -> design view ...is there any way to read the program of sql server 2005 DMV.

  Thanks and regards

  Ashwin vp

  Ashwin VP
  CSC India ...

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 16, 2010 at 5:48 am

  #1119206

  It's not a program, it's just a class of commands that the SQL engine understands, just like CREATE TABLE and the like.

  You can use sp_helptext to see the definition of a DMV. Most aren't too exciting as they're just referencing internal resultsets or hidden tables

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• ashwin4all1

  Ten Centuries

  Points: 1131

  More actions

  February 17, 2010 at 3:45 am

  #1119937

  Thanks gail ...am looking for it...Now i can see the base table of DMV.

  Ashwin VP
  CSC India ...