I have some MS Access code that uses ODBCDirect to execute some sql statements in a SQL 2008 R2 DB.
The sql statements do not specify the schema name so subsequently are executed using the windows user as the schema name and not the result im looking for. The schema should be dbo.
All users belong to a Windows group which is a SQL login.
I read that if I change the owner of the schema dbo to the windows group that sql statemenets that do not specify a schema will default dbo.
So I tried to change owner of the schema to the windows group but get message
Alter failed for schema 'dbo'
I do seem to change alter permission on schemas in the DB as well.
Does sql allow you to change the owner if so how???