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 -
For the enterprise sys admin by the enterprise sys admin
Categories
- AntiVirus (1)
- App-V (1)
- Certificates (2)
- Exchange (6)
- Geek (14)
- Office Communications Server (8)
- Scripting (13)
- Powershell (9)
- SMS / SCCM (17)
- Storage (3)
- Tools (28)
- VMWare (2)
- Windows (31)
Archive
- 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)
Random Quote
Pareto’s Principle, the 80/20 Rule, should serve as a daily reminder to focus 80 percent of your time and energy on the 20 percent of you work that is really important. Don’t just “work smart”, work smart on the right things.
Recommended Blogs
Recent Entries
- Installing SQL Server 2005 on a Windows Server 2008 R2 Cluster fails
- Add the classic menu theme to Office 2007 & 2010
- New Microsoft TS certifications
- SCCM clients not installing in native mode
- App-V sequenced applications not keeping settings / preferences
- Group Policy Search
- Great tool to install multiple applications at once
- Windows 7 enable Recent Items via group policy
- How to export RSS feeds in Outlook 2010
- SuperFlow for SCCM Operating System Deployment via PXE
Recent Comments
- goof1427 in Office Communicator error - Cannot synchronize add…
- jrothlis in Add the classic menu theme to Office 2007 & 2010
- liviui in Office Communicator error - Cannot synchronize add…
- pcvchriskmg in Windows 7 enable Recent Items via group policy
- danovich in Group Policy Search
- jrothlis in Group Policy Search
- bizzarro in Send SCCM task sequence email report
- bizzarro in Send SCCM task sequence email report
- ultrafris in Windows 7 enable Recent Items via group policy
- danovich in Send SCCM task sequence email report
Random Selection of Posts
© 2009 - danovich.com.au - is proudly powered by WordPress.