- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
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.
Connect with top rated Experts
18 Experts available now in Live!