HOW TO find SQL Server edition info

While deploying applications, you may require details of the SQL Server edition or other properties, like I did when I had to find if the latest Service Packs were installed and this function is useful to know:

SELECT SERVERPROPERTY('ProductLevel')

Edition
ProductVersion
ServerName
Collation
Engine Edition
InstanceName
IsClustered
IsFullTextInstalled
IsIntegratedSecurityOnly
IsSingleUser
IsSyncWithBackup
LicenseType
MachineName
NumLicenses
ProcessID

Comments

Post a Comment

Popular posts from this blog

HOW TO dynamically generate a Word document with custom header & footer

Image
Way back in 2004, a project I was working on required a web page to be exported as a Word document (.DOC). Without relying on any components, I utilized the Office XML & HTML technique to implement this feature. I posted my sample on CodeProject to seek feedback. Over the years, I've received some generous comments & feature requests. Many wanted to know how to add a header & footer to the dynamically generated Word document. With the help of the Microsoft Office HTML and XML Reference , I devised a hack to add a lacklustre header and/or footer . Some folks wanted to customize the contents of the header & footer but when they tried with my hack that offered limited functionality, the header/footer text showed up in the document body to their annoyance. This July, an ingenious developer posted a hack that can overcome this problem, in the Comments section of my CodeProject article. His practical workaround was to pack the duplicating header/footer text inside a t...
Read more

HOW TO add a header or footer to a dynamically generated Word document

Image
There was a question recently on my CodeProject article "Dynamically generate a MS Word document using HTML & CSS" . The article describes how to generate a Word document programmatically without using any components, by exploiting the formatting features exposed through Office XML and CSS. The questioner wanted to know how to add a custom header and footer and show something like Page X of Y (total pages). Based on what I have tried so far, showing a header and footer using Office XML in MS Word is not as easy as it is in Excel . If you want to keep the code simple & don't need any great fireworks i.e. you will just settle for page numbers in the header or footer then it's a matter of adding a few lines to the original source code. The code can be viewed at this Github Gist Update (1-Sep-2010): To add a custom header & footer, check this new post To add a footer that shows Page number at the bottom right, here are the steps - 1) Add these classes...
Read more

This Week I Learned - Week 11 2026

Image
This Week I Learned - * Meta has acquired Moltbook, the viral "social network for AI agents" where bots (many powered by OpenClaw) interact while humans observe. * Meta acquired Manus, the AI agent startup for approximately $2 billion.  * OpenClaw’s creator, Peter Steinberger, has joined OpenAI. * The OpenClaw project has been moved to an independent open-source foundation to ensure it remains free and accessible under its MIT license. *  The Batch - - The U.S. military uses AWS to run the unclassified version of Anthropic Claude. - Claude is integrated with Maven Smart System (MSS), a system for targeting and logistics built by Palantir. - Claude/MSS played a role in the January operation that captured Venezuelan president Nicolás Maduro, but the actions in Iran are its first use in “major war operations.” - The Qwen3.5 family of open-weights vision-language models includes impressive larger models as well as a smaller one that outperforms an OpenAI open-weights model 1...
Read more