DBCC Command via OPENROWSET

• MarvinTheAndriod

  SSCarpal Tunnel

  Points: 4972

  More actions

  January 21, 2009 at 9:36 am

  #125786

  Is it possible to issue a DBCC Command like DBCC SQLPERF(LOGSPACE) from via an OPENROWSET I googled a number of posts across various websites where people are having a problem doing this, but there is no solution available. I haven’t been able to do this eithier. Anyone have any ideas ?

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  January 22, 2009 at 6:46 am

  #931121

  SELECT a.* FROM OPENROWSET('SQLOLEDB',

  'DRIVER={SQL Server};SERVER=ServerName;Trusted_Connection=yes;',

  'SET NOCOUNT ON;SET FMTONLY OFF; exec (''dbcc sqlperf(logspace)'')') AS a

  MJ