JosiahSiegel · May 26, 2020 14:09
diff --git a/link_user.sql b/link_user.sql
 USE [AdventureWorks]
 GO
 ALTER USER [Joe] WITH LOGIN = [Joe]
 GO
diff --git a/link_user_all_filtered.sql b/link_user_all_filtered.sql
 DECLARE @command NVARCHAR(MAX) 

 SELECT @command = 
 N'IF ''?'' NOT IN(''master'', ''model'', ''msdb'', ''tempdb'') 
 BEGIN
 	USE [?]
 	ALTER USER [user] WITH LOGIN = [user]
 END
 ' 

 EXEC sp_MSforeachdb @command
	DECLARE @command NVARCHAR(MAX)

	SELECT @command =
	N'IF ''?'' NOT IN(''master'', ''model'', ''msdb'', ''tempdb'')
	BEGIN
	USE [?]
	ALTER USER [user] WITH LOGIN = [user]
	END
	'

	EXEC sp_MSforeachdb @command