Invalid Object Name

If you receive the above error when using temporary tables in stored procedures with the Visual Studio dataset designer, add the following to your stored procedure:

SET FMTONLY OFF;

Now, you should be able to drag and drop your stored procedure to the dataset designer without the error message popping up.