Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
miranwar
Posting Yak Master
125 Posts |
 Posted - 2003-10-14 : 05:10:49
|
| hello,Can anyone help. The setting FMTONLY is supoosed to return the Meta schema from the SP Instead of the result set. The problem is that if the SP has a temporary table swiching FMTONLY on will create an error"Invalid Object name #temptable". Is there any way round this ?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-10-14 : 08:30:53
|
| Yes, you can use:SELECT TOP 0 * FROM #myTable...or...SELECT * FROM #myTable WHERE 1=2 |
 |
|
|
miranwar
Posting Yak Master
125 Posts |
Posted - 2003-10-14 : 09:29:27
|
| Is there anyway you can check if FMTONLY is on...In that way i could configure my SP to return meta data or the result set |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-10-14 : 22:36:55
|
| No, I don't think so. Best thing to do is just turn it on if you want it on, and off if you want it off. |
|
|
|
|
|
|
SET FMTONLY ON & Temp Tables