Post reply

Remote DBCC

  • 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?

  • 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 '].

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply