Viewing 12 posts - 1 through 12 (of 12 total)
So the deleted virtual tables are similar to the oracle redo/undo.
April 10, 2015 at 3:31 pm
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...
April 10, 2015 at 3:13 pm
Based on the tables above, in theory would this work:
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
ALTER TRIGGER [dbo].[ABC_trigger] ON [dbo].[ABC]
IF UPDATE (ruleCollectionJSON)
April 10, 2015 at 2:45 pm
Can anyone provide specific code?
April 10, 2015 at 2:41 pm
How would I do that?
April 10, 2015 at 1:39 pm
That did it!
April 7, 2015 at 10:16 am
What if I need the precision to be to the nearest 0.0000? Do I need to add a cast statement too?
April 7, 2015 at 9:39 am
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...
April 25, 2013 at 7:31 am
Thanks again everyone!
April 12, 2012 at 1:35 pm
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....
April 12, 2012 at 11:42 am
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...
April 12, 2012 at 9:37 am
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...
April 6, 2012 at 9:46 am