Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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