Avoiding invalid object name errors with temporary tables for BizTalk, Reporting Services and apps using SET FMTONLY

added by DotNetKicks
10/18/2017 12:58:47 PM

1 Kicks, 103 Views

When applications need to call stored procedures, they try to work out what the returned data will look like ie: which columns come back, what data types are they, etc. The old way of doing this was to call SET FMTONLY ON.