Remote DBCC

• sxg6023

  SSCrazy

  Points: 2918

  More actions

  November 19, 2003 at 12:50 pm

  #64877

  Is there any way to remotely execute the DBCC commands like a remote procedure. I meant something like,

  RemoteServer.master.dbo.DBCC CheckdB?

• sxg6023

  SSCrazy

  Points: 2918

  More actions

  November 19, 2003 at 1:07 pm

  #482734

  I was hoping this would work:

  SELECT * FROM OPENQUERY (BIGDB, 'DBCC showfilestats ')

  But, doesnot.

  I get:

  Server: Msg 7357, Level 16, State 2, Line 1

  Could not process object 'DBCC showfilestats '. The OLE DB provider 'SQLOLEDB' indicates that the object has no columns.

  OLE DB error trace [Non-interface error: OLE DB provider unable to process object, since the object has no columnsProviderName='SQLOLEDB', Query=DBCC showfilestats '].

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  November 19, 2003 at 1:27 pm

  #482743

  Create a stored procedure to run dbcc showfiles in remote server and call it from local server like exec remote.master.dbo.usp_showfiles.