Viewing 11 posts - 1 through 11 (of 11 total)
Yup, like I said, I was obviously having a dense day. Cheers.
November 16, 2012 at 7:06 am
I'm obviously having a dense Friday.
How does the explanation (all about @@error) relate to the question: "What is returned from #tblTrans when you run the below code:"...?
I'm not saying that...
November 16, 2012 at 6:27 am
Neil Thomas (5/23/2012)
So that means that when xact_abort is set to off thenBEGIN TRANSACTION
...
COMMIT TRANSACTION
does not do as expected.
What's the default setting on a fresh install of SQL?
Ah, an...
May 23, 2012 at 12:45 am
So that means that when xact_abort is set to off then
BEGIN TRANSACTION
...
COMMIT TRANSACTION
does not do as expected.
What's the default setting on a fresh install of SQL?
May 23, 2012 at 12:44 am
Yup, they'll be added. I just wanted to understand how it had got into that state.
It's supposed to have been backed up as part of a system backup (hence somebodies...
February 25, 2010 at 8:35 am
BrainDonor (2/25/2010)
If the database was switched from Simple to Full recovery and a backup has never been run it is possible that it isn't in Full recovery mode at all.http://msdn.microsoft.com/en-us/library/ms178052.aspx
BrainDonor.
Hmm,...
February 25, 2010 at 4:53 am
There's no jobs on the server at all, backup or otherwise.
February 25, 2010 at 4:52 am
I'm interested, but only because I think it's about time I replace my P4 PCs. The I7s are expensive, but when I read about the I5s, I started to think...
September 11, 2009 at 4:00 pm
Where I used to ork, we ran AV software on SQL Server boxes as well. We were able to set up scanning exclusions for specific groups of servers, but by...
February 9, 2009 at 1:57 am
Glad I'm not the only one who thought that their "correct" answer was flawed.
Perhaps instead of saying
3 100GB drives as a RAID 5 array and 2 100GB drives...
May 16, 2007 at 12:36 am
Viewing 11 posts - 1 through 11 (of 11 total)