Ensure current user uses dbo schema when performing database upgrades
Created:
7/13/2021 10:33:41 PM by Alana Tripp
Status:
Completed on
Last pulled:
7/30/2021 11:35:45 AM
Description:
This can just be added to the untracked DDL-DML scripts.
```
IF (SCHEMA_NAME() <> 'dbo') BEGIN
DECLARE @SQL NVARCHAR(MAX) = 'ALTER USER [' + CURRENT_USER + '] WITH DEFAULT_SCHEMA = [dbo]'
PRINT 'Changing default schema ("' + SCHEMA_NAME() + '") to dbo via: ' + @SQL
EXEC sp_executesql @SQL
PRINT 'Schema changed.'
END
```