Question

  Asked: May 16 2008   10:05 AM GMT
  Asked by: Mangesh jadhav


run DBCC SQLPREF on linked server.


SQL Server administration, Database Consistency Checker, DBCC, Linked servers

I want to run DBCC command on linked server remotly

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



You would have to execute sp_executesql on the remote machine with the DBCC command within the dynamic SQL code block. DBCC commands are not setup to be run remotely.

exec Server2.master.dbo.sp_executesql 'DBCC ...'
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server and Database.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

dbcc  |   May 28 2008  12:35AM GMT

[…] DBCC SQLPREF on linked server. New Question Created by Mangesh <a href="jadhavhttp://itknowledgeexchange.techtarget.com/itanswers/run-dbcc-sqlpref-on-linked-server/Inflation" rel="nofollow">jadhavhttp://itknowledgeexchange.techtarget.com/itanswers/run-dbcc-sqlpref-on-linked-server/Inflation</a> goal stays but could be exceeded - BSP GMA NewsMANILA, Philippines - The Bangko Sentral ng […]