Execuete DBCC

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  March 16, 2006 at 9:35 pm

  #113755

  Hi all,

  I want to execute DBCC commands on a remote server from my local server.

  Is it possible.

  for Example we can execute stored procedures on a remote server or linked server by using the liniked server name.

  Thanks

  from

  Killer

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  March 19, 2006 at 7:41 pm

  #627492

  Hi,

   

  This is how we can execute the DBCC command on linked server or Remote Servers.

  EXEC svr_test.master.dbo.sp_executesql N'DBCC MEMORYSTATUS'

   

  from

  Killer