You do realize that this is a 4 year old thread, and the OP has not been active for 2 years???

This is not a good idea. It's a very bad use of a trigger.  

I would create a "queue" table, and in the trigger, insert into that.  I would...

I love it when developers need to do some sort of update on a lot of rows, such as re-calculating the price of something, and they put a one row...

This looks like a place to start
str = str & "AND (NOT (LP.EffDate IS NULL)) "
How about
AND LP.EffDate IS NOT NULL

And, why are you...

Defensive Database Programming 

And, did you look on this site?

https://www.sqlservercentral.com/Books/

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null

$a = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$DateTime = (Get-Date).ToString("yyyyMMdd-HHmmss")
$instanceName = "$(ESCAPE_SQUOTE(SRVR))";
$instanceName = $instanceName.Replace("\","$")
$directory_location = "H:\SQL_Backups" + $instanceName + "\Objects"
new-item ...