Home > IT Answers > Database > run DBCC SQLPREF on linked server.
Mangesh jadhav
5 pts.
 run DBCC SQLPREF on linked server.
Database Consistency Checker, DBCC, Linked servers, SQL Server administration
I want to run DBCC command on linked server remotly

Software/Hardware used:
ASKED: May 16, 2008  10:05 AM
UPDATED: May 23, 2008  5:08 PM
RELATED QUESTIONS
Answer Wiki:
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. <pre>exec Server2.master.dbo.sp_executesql 'DBCC ...'</pre>
Last Wiki Answer Submitted:  May 23, 2008  5:08 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _