So the deleted virtual tables are similar to the oracle redo/undo.

Correct?!

Thank you!

Just found that about 10 minutes ago. I didn't realize I could pull it from deleted.

Thanks everyone. I was so close on my first attempt. I just wanted...

Based on the tables above, in theory would this work:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[ABC_trigger] ON [dbo].[ABC]

AFTER UPDATE

AS

IF UPDATE (ruleCollectionJSON)

BEGIN

INSERT...

Can anyone provide specific code?

How would I do that?

Thanks Lowell.

That did it!

You rock,

What if I need the precision to be to the nearest 0.0000? Do I need to add a cast statement too?

Steve,

I'm a religious follower of the SQLServerCentral.com site. Also thrilled to hear that you are coming here to Fargo. (That's what I call home.) You'll be disappointed to hear that...

Will do.

Thanks again everyone!

Thank you, guys. I changed the frequency to every 15 minutes and now my log_reuse_wait_desc is finally set to NOTHING. So it looks like the Log will finally get reused....

I'm aware that the shrink was a bad idea. It just appears that the log file is 40GB and not getting re-used but just continues to extend due to the...

John,

Thanks for posting. I've automated as many tasks as possible using a combination of TSQL, Powershell and VBscripts. One thing I have done is built a template and rolled it...