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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-30 : 13:58:57
|
| Libania writes "I have a ASP page that calls (only once!!!) a SQL procedure.The procedure is very simple and inserts a row in a table.But Profiler shows me that the proc was called twice!!After the procedure is completed, Profiler shows SET NO_BROWSETABLE ON and the procedure is called again. After the second time completed, is shows:SET FMTONLY ON EXEC MyProc SET FMTONLY OFFWhat do I do???Thanks in advance!" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-04-30 : 16:14:49
|
| SET FMTONLY ON EXEC MyProc SET FMTONLY OFFThis doesn't process data in the sp but just gets the column format of output. You are presumably doing something in your app that needs the resultset format so it is executing this.See SET FMTONLY ON in bol.Be careful as it probably won't work with a temp table in the SP.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SET FMTONLY OFF + SET NO_BROWSETABLE ON + Duplication