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 Question
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.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
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 ...'
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 […]
