TSQL to get SQL Server properties
Posted by nethan on November 13, 2009 · Leave a Comment
TSQL script to get common SQL Server properties (edition, instancename et al)
SELECT
SERVERPROPERTY('Collation') Collation,
SERVERPROPERTY('Edition') Edition,
SERVERPROPERTY('Engine Edition') EngineEdition,
SERVERPROPERTY('InstanceName')...
Source: .NET Developer Notes
Filed under BLOG · Tagged with
Disclaimer: PinoyBlogoSphere.com(PBS) claims no credit for any content(posts, articles, texts, images, videos) featured on this site unless otherwise noted. All contents are copyright to their owners/sources. PBS is in no way responsible for or has control of the content of any external web site links. Information on this site may contain errors or inaccuracies; we do not make warranty as to the correctness or reliability of the site’s content. If you own rights to any of the content, and do not wish them to appear on this site, please contact us via e-mail and they will be removed.
Random Posts
- December 5, 2009 -- Tek Tok Podcast review
- May 20, 2008 -- Pinoy Blogosphere News
- January 17, 2010 -- 3 Idiots Movie Online for Free
- January 18, 2010 -- Nicanor Perlas–Championing alternative politics for a better Philippines
- May 7, 2010 -- Overload Hits Halo Reach Beta Release
- December 16, 2009 -- Free Livelihood and Skills Seminar
- July 4, 2008 -- Sun Dictates the Climate Change
- December 23, 2009 -- Pacquiao-Mayweather Round 1: Drug Test
- January 7, 2010 -- Listen to the new Charice!
- October 5, 2009 -- FOUNTAIN
- February 17, 2010 -- Study At Your Own Convenience
- October 28, 2009 -- Nokia E63 Review
- June 18, 2010 -- Patrombon, partner in Webber finals
- April 10, 2010 -- Giving away 5 iPhone Tiki Cases
- February 4, 2010 -- Kellan Lutz CK Ads
- November 23, 2009 -- 45 Amazing Free Fantasy and Sci-fi Art Wallpapers
- December 24, 2009 -- Direct Satellite TV
- August 17, 2007 -- taste the Philippines
- December 5, 2009 -- 2010 World Cup Final Draw Results
- April 21, 2010 -- WANTED: Chairperson (Electrical Engineering)