Everything you need to know about backup and disaster recovery with AWS, for FREE!
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.