Viewing 6 posts - 1 through 7 (of 7 total)
Brilliant.
It's just the safety net I was looking for.
Charley Jones
A+, ITIL, MCAD, MCDBA, MCITP: Sql Server 2005 Adminstration, MCT,
MCTS: Sql Server 2005, MCP, MCSA, MCSE, MOUS, PMP
President and Founder S3oLV.Com: Sql Server Society of Las Vegas
President and Founder LVXUG.Com: Las Vegas XNA Users Group
October 24, 2012 at 10:48 am
Great article.
I liked the technique of using the parameter in the connection string.
Didn't think that was possible,
Nice hack!
Just a couple of small problems though:
1) Your creation script does not match...
Charley Jones
A+, ITIL, MCAD, MCDBA, MCITP: Sql Server 2005 Adminstration, MCT,
MCTS: Sql Server 2005, MCP, MCSA, MCSE, MOUS, PMP
President and Founder S3oLV.Com: Sql Server Society of Las Vegas
President and Founder LVXUG.Com: Las Vegas XNA Users Group
May 6, 2008 at 10:23 am
I was clipping the article to paste to the Linux Admin!
Touche', you got me man! Nice job! And I was being so...
Charley Jones
A+, ITIL, MCAD, MCDBA, MCITP: Sql Server 2005 Adminstration, MCT,
MCTS: Sql Server 2005, MCP, MCSA, MCSE, MOUS, PMP
President and Founder S3oLV.Com: Sql Server Society of Las Vegas
President and Founder LVXUG.Com: Las Vegas XNA Users Group
April 3, 2006 at 11:46 am
It makes sense to consolidate, especially in the light of service hardening, such as clustering or mirroring technology. It's expensive, but can be better justified by hardening several instances prone...
Charley Jones
A+, ITIL, MCAD, MCDBA, MCITP: Sql Server 2005 Adminstration, MCT,
MCTS: Sql Server 2005, MCP, MCSA, MCSE, MOUS, PMP
President and Founder S3oLV.Com: Sql Server Society of Las Vegas
President and Founder LVXUG.Com: Las Vegas XNA Users Group
March 15, 2006 at 9:41 am
Kudos on the use of openrowset to test the userid/password combination. Always great to check your work, especially if you can automate that check!
Charley Jones
A+, ITIL, MCAD, MCDBA, MCITP: Sql Server 2005 Adminstration, MCT,
MCTS: Sql Server 2005, MCP, MCSA, MCSE, MOUS, PMP
President and Founder S3oLV.Com: Sql Server Society of Las Vegas
President and Founder LVXUG.Com: Las Vegas XNA Users Group
July 19, 2005 at 10:34 am
Ya know, there are always two ways of looking at a problem. One person's push is another's pull.
Another version of the solution is to have server A publish the...
Charley Jones
A+, ITIL, MCAD, MCDBA, MCITP: Sql Server 2005 Adminstration, MCT,
MCTS: Sql Server 2005, MCP, MCSA, MCSE, MOUS, PMP
President and Founder S3oLV.Com: Sql Server Society of Las Vegas
President and Founder LVXUG.Com: Las Vegas XNA Users Group
July 1, 2005 at 12:23 pm
Viewing 6 posts - 1 through 7 (of 7 total)