Warning : SQM1014: Unable to extract stored procedure 'dbo.myStoredProcedure' from SqlServer. Invalid object name '#projectAssignmentsIt cannot work with the results, obtained using the dynamic SQL in the stored procedure. (You could see some examples here: http://code.google.com/p/lbob/wiki/SqlMetal )
CREATE PROCEDURE [dbo].[MyStoredProcedureWrapper] @employeeId int, @startDate datetime, @endDate datetime AS BEGIN . SET NOCOUNT ON DECLARE @assignments TABLE ( projectid int, projectname varchar (50), ... ) INSERT INTO @assignments EXEC MyStoredProcedure @employeeId , @startDate , @endDate SELECT * FROM @assignments ENDThat did the trick - SqlMetal does not complain anymore and creates the proxy classes code with no error.