Remote SQL Server debugging is done using Distributed Component Object Model (DCOM), and this can be tricky to configure properly. First, you need to install the full remote debugging components on the remote machine using the Visual Studio CD. You may also need to repeat this process every time the SQL Server is upgraded with a service pack or a patch. Then you must configure DCOM on the SQL Server machine to allow a remote user to attach the debugger to a process on the SQL Server machine. To do this, you should follow the instructions in the SDK documentation, as the procedure is different for each operating system. You can find this documentation at ms-help: //MS.VSCC/MS.MSDNVS/vsdebug/html/vxtskconfiguringdcomforsqldebugging.htm . For more information about installing and using remote debugging, please see Chapter 15.