If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.
I try the following without good result
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[MSmerge_del*]')) DROP TRIGGER [dbo].[MSmerge*]
$DIRECTORY="c:\temp" $script=$DIRECTORY + "\" + ".Drop.Triggers.sql" $Sql = [IO.File]::ReadAllText($script) $Sql -replace '(?s)drop trigger \[MSmerge_.*?\r\nGO' -replace '(?s) \[MSmerge_.*?\r' , '' | Out-File $script
Join the community of 500,000 technology professionals and ask your questions.