Remote SQL Server debugging
back in my previous company, i was not able to debug stored procedures remotely using either visual studio (i like its debugger by the way) or through Query Analyzer. back then, the KB's that i found just talks about a settings when the SQL 2000 was installed, etc. I know that I need to have some settings to configure but I didn't bother to ask help from technical. was surprised this morning what greeted my on my mailbox, just what i needed back then:
FIX: Remote SQL Server debugging does not work in Visual Studio .NET 2003 after you install Windows XP Service Pack 2 (http://support.microsoft.com/default.aspx/kb/886680/en-us)