.Net 2.0 & SQL Server 2008 Hanging Process
I created a simple .Net web service which runs a very simple query (which should normally be very quick). The query is something like this: SELECT v.email FROM dbo.Reporting r INNER JOIN dbo.Reporting_EmailList el ON r.reportID = el.reportID INNER JOIN OtherDB.dbo.V_ActiveDir v ON el.userGUID = v.objectGUID WHERE r.reportID = @repor...