In this quick script I am assuming the Windows domain is called ‘DOM’ …
-- ChangeDefaultSchemaToDboWhereNull.sql
DECLARE @cmd varchar(1000)
SET @cmd =
'USE ? IF DB_ID(''?'') > 4 SELECT ''USE ?; ALTER USER ['' + name + ''] WITH DEFAULT_SCHEMA = [dbo]''
FROM sys.database_principals
WHERE default_schema_name IS NULL
AND [name] LIKE ''DOM\%'''
IF OBJECT_ID('tempdb..#output') IS NOT NULL DROP TABLE #output
CREATE TABLE #output
(command varchar(1000))
INSERT INTO #output
EXEC sp_MSforeachdb @cmd
SELECT *
FROM #output
Database Consultant 