I am running into problems debugging T-SQL from within Management Studio 2008 under Windows 7, running against SqlServer 2008 (64 bit) running on Windows Server 2008. All software updates have been applied on both the client and the server.

The error message complains about a potential problem with SSDEBUGPS.DLL not being found or not being registered properly on "the Visual Studio machine". I'm not sure if that's referring to the client or the server (I have VS2008, and Management Studio 2008, installed on both the client and the server).

SSDEBUGPS.DLL exists on the server, in both 64 bit and 32 bit folders. It does not exist on the Windows 7 client, and I cannot find any way of installing it there (I even tried copying the 32 bit version from the Server 2008 box, but regsvr32 blew up when I tried to register the DLL).

I've tried a whole bunch of "solutions" from the MSDN support system, but none of them work or apply to my situation.

Frankly, I'm amazed that something as important, and basic, as remote debugging is so badly documented, and apparently so fragile.

Is it even possible to do remote T-SQL debugging with this setup? Is something not supported under Windows 7?

- Mark

Hi Mark,

Thank for reporting this issue.

The SSDEBUGPS.DLL file is installed if you select SQL Server 2008Workstation Componentsoption of SQL Server 2008 installation.

Another option is to manually copy and regsvr32 SSDEBUGPS.DLL. Ididn't encounterany error when register the DLL in windows 7. Can you let me know what error occurs on your machine?

Hongye Sun [MSFT]
MSDN Subscriber Support in Forum
If you have any feedback on our support, please contact msdnmg @ microsoft.com

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.