SQL Proc temp tables and TableAdapter

I'm not much of a web design guy but I have to do it once in a while.

I needed to display some information on a web page that's in SQL.  I like to call stored procs on the SQL server so it's easier for me to modify the logic if needed.

Anyway the stored proc uses a bunch of temp tables and returns one of them.  When I tried to use the tableadapter config wizard in VS2005 the wizard failed for the temp table.  Apparently the wizard could not get the temp table metadata. 

To work around this put

SET FMTONLY OFF

in the stored proc, generate the tableadapter and then comment it out.

Print | posted on Wednesday, March 12, 2008 12:16 PM