I am using a GUI tool to upload data in my SQL Server 2016 database. The user being used for above task has been granted sysadmin permission I created a dedicated schema to store above data. This schema is owned and default to above said user. The issue is, when i upload data it stores in dbo schema instead of dedicated schema and i couldn't revoke sysadmin priv from this user.
Kindly let me know how to upload data to this dedicated schema without revoking sysadmin priv ?