You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
Calling procedure with CommandBehavior.SchemaOnly behavior wraps sql with SET FMTONLY ON and SET FMTONLY OFF lines which results in following errors:
// for fully-qualified name (db.schema.proc)
Attempt to locate entry in sysdatabases for database 'SET FMTONLY ON
TestDataCore' by name failed - no entry found under that name. Make sure that name is entered properly
// for procedure name only:
Stored procedure 'SET FMTONLY ON
AddIssue792Record
SET FMTONLY OFF' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
Looks like SET FMTONLY ON/OFF should be sent in separate batches for procedures (at least doing it manually helps).
Environment
AdoNetCore.AseClient nuget package version (e.g. 0.18.0)
The text was updated successfully, but these errors were encountered:
Describe the bug
Calling procedure with
CommandBehavior.SchemaOnly
behavior wraps sql withSET FMTONLY ON
andSET FMTONLY OFF
lines which results in following errors:Looks like SET FMTONLY ON/OFF should be sent in separate batches for procedures (at least doing it manually helps).
Environment
AdoNetCore.AseClient
nuget package version (e.g.0.18.0
)The text was updated successfully, but these errors were encountered: