I’ve often needed to work out what service pack level SQL is running or whether it is a Enterprise or Standard installation. It’s not obvious how to do this and it’s not as simple as going to Help –> About. The following query will work in SQL 2000 and above. To run it, for example [...]
- danovich.com.au -
Designing & deploying IT infrastructure in the enterprise
Categories
- AntiVirus (1)
- App-V (2)
- Certificates (4)
- Exchange (8)
- Geek (22)
- OCS / Lync (22)
- Opalis / Orchestrator (2)
- Scripting (30)
- Powershell (17)
- SMS / SCCM (77)
- Storage (4)
- Tools (47)
- VMWare (3)
- Windows (50)
Archive
- May 2012 (5)
- April 2012 (3)
- March 2012 (7)
- February 2012 (5)
- January 2012 (6)
- December 2011 (6)
- November 2011 (1)
- October 2011 (4)
- September 2011 (3)
- August 2011 (5)
- July 2011 (2)
- June 2011 (1)
- May 2011 (3)
- April 2011 (5)
- February 2011 (7)
- January 2011 (5)
- December 2010 (9)
- November 2010 (2)
- October 2010 (5)
- September 2010 (3)
- August 2010 (3)
- July 2010 (1)
- June 2010 (4)
- May 2010 (4)
- April 2010 (2)
- March 2010 (9)
- February 2010 (7)
- January 2010 (8)
- December 2009 (1)
- November 2009 (4)
- October 2009 (5)
- September 2009 (3)
- August 2009 (2)
- June 2009 (3)
- May 2009 (1)
- March 2009 (2)
- February 2009 (4)
- January 2009 (2)
- December 2008 (7)
Recommended Blogs
Tech Links
- Best Free Windows Software
- Dr Web online URL check
- Environment variables
- Live Mesh
- Microsoft Connect
- Microsoft Discussion Newsgroups
- Microsoft IPD
- Microsoft KB monitoring
- Microsoft TechNet Forums
- MX Lookup Tool
- NSLookup
- Online Script Decoder
- PortableApps
- Sendoid
- Speedtest
- SSL Certificate Check
- This blog's 2011 annual report
- TVCatchup.com
Random Quote
I know not with what weapons World War III will be fought, but World War IV will be fought with sticks and stones..
— Albert Einstein
Recent Entries
- SCCM report – Packages that have been updated since original content was distributed
- SCCM package containing a plus (+) sign / symbol in a filename
- PowerShell Scripts for System Center
- SCCM 2012 and client side BITS…
- SCCM 2012 Prerequisite Downloads
- SCCM 2012 Active Directory Schema changes
- How to tell which PXE/WDS server a machine booted from
- Change SCCM package source
- HP driver packages for SCCM
- Running multiple commands in SCCM ‘Run Command Line’ Task Sequence step
Recent Comments
- SiRu in HP iLO Integrated Remote Console is unavailable
- Andy in Windows 7 enable Recent Items via group policy
- danovich in PowerShell Scripts for System Center
- [SCCM 2012] PXE Boot in x86 or x64 Boot Images during SCCM OS deployment
- James in SCCM database size
- killragtshirts in Difference between IT architect roles
- Task sequence error– How to copy … in SCCM task sequence log file locations
- SCCM 2012 Active Directory Schema c… in SCCM Active Directory Schema changes
- danovich in List of recommended SCCM hotfixes
- danovich in Free online training for System Center 2012 includ…
© 2009 - danovich.com.au - is proudly powered by WordPress.