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
When I do good, I feel good; when I do bad, I feel bad. That’s my religion..
— Abraham Lincoln
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
- Birlinn Web Blog in Windows 7 locks out domain account
- 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
Random Selection of Posts
© 2009 - danovich.com.au - is proudly powered by WordPress.