FIX: SQL Breakpoint Not Hit After Executing SP in Another DB

REFERENCES

Sample Code

   /* Sample SP which shows the problem */ 
   Create Procedure sp_MySP
   As
   SELECT * FROM employee

   /* Breakpoints set after this call will not be hit */ 
   EXEC OtherDB.dbo.sp_SomeSP

   SELECT * FROM Authors

   RETURN (0)

   -----------
   /* Sample SP with a workaround */ 
   /* Add one line of code */ 

   Create Procedure sp_MySP
   As
   SELECT * FROM EMPLOYEE

   EXEC OtherDB.dbo.sp_SomeSP

   /* This causes the database context to be changed back to original */ 
   /* Breakpoints will now be hit */ 
   EXEC sp_MySP2

   SELECT * FROM Authors

   RETURN (0)

   /* Stored procedure called from above */ 

   Create Procedure sp_MySP2
   As
   RETURN (0)