Viewing 15 posts - 496 through 510 (of 817 total)
If I'm understanding your question correctly:
To set your primary instance back to being the PRINCIPAL, issue the following command:
-- http://msdn.microsoft.com/en-us/library/bb522476(v=sql.100).aspx
ALTER DATABASE [yourDatabase]
SET PARTNER FAILOVER
GO
To change the timeout setting:
ALTER DATABASE [yourDatabase]
SET...
May 29, 2012 at 8:44 am
The link takes you to the SQL Server 2012 entry, it just doesn't tell you that very well. Look on the left hand navigation hierarchy, it shows 'Books Online...
May 21, 2012 at 2:47 pm
Sounds a lot like a typical Giants game. I'd pinch run for Posey on first with Blanco (the speedy jack rabbit) and let Pill pinch hit for Huff. ...
May 18, 2012 at 10:29 am
1. I'm using the 'zBench' theme. I wish I could find one that I could make do what I want and not look like everyone else. And of...
May 17, 2012 at 10:00 am
Got it to accept the dynamic connection string using the above layout but didn't think past that. The Maintenance Plan tasks are asking for more than just a connection...
May 9, 2012 at 3:02 pm
Grats Steve, sounds like fun. Tell anyone who asks about the lip that you were in a bar fight and that they should see the other guy. Then...
April 23, 2012 at 11:05 am
Markus (4/19/2012)
Jamie Moyer pitching for the Rockies and got the win and with that win he became the oldest player ever to win a...
April 19, 2012 at 9:24 am
Thanks Jerry. Indeed, I did not register the database first as a data tier application then try and upgrade it. I kept reading the same areas in BOL...
April 12, 2012 at 2:01 pm
I snooze, I lose!
I'm just glad it got written. Take all the feedback with an open mind, it'll only make you better in the long run.
April 10, 2012 at 1:20 pm
Giants start out 0-3, starting pitching gets rocked and the bats are talkin'....weird opening weekend for SF. At least the Yankees and Red Sox are in the same boat.
Steve,...
April 9, 2012 at 11:40 am
2 billion, yikes. One of the co-owners of the GS Warriors is in the ownership group for the Dodgers now.....WTF?!?!??
Lincecum and Kershaw horsin' around doin' photo ops...
$25 cheap tix...
March 28, 2012 at 11:26 am
Good point Lynn, suspending the mirroring won't work.
Back to the drawing board.
March 13, 2012 at 12:02 pm
Traditionally I always disliked the DH and the style of baseball it promotes. But I've always been frustrated with a pitcher's lack of ability at the plate and the...
March 7, 2012 at 9:34 am
I didn't get a chance to listen to any games this weekend (SQL Saturday in Mountain View was a blast) but am excited for baseball on the radio again.
Here's to...
March 5, 2012 at 9:33 am
Viewing 15 posts - 496 through 510 (of 817 total)