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

Kai-Fu Lee on China-US AI Race - Q&A Transcript from a Bloomberg Interview

Image
Kai-Fu Lee, Chairman of Sinovation Ventures and author of  AI Superpowers and  AI 2041: Ten Visions for Our Future on the China-US AI Race Q: There's still a lot of challenges when it comes to the whole monetization of AI, according to his perspective. In the last three years, though, how have you looked at this whole evolution of China AI versus the US, and what are the advantages and challenges for China? A: Yeah, so firstly, I disagree on the prospects for the USA. USA because yes, you look at OpenAI, it's making half billion spending 40 billion. It looks like a bad balance sheet, but most of that 40 billion is spent for future revenues. And if you believe there are 2x, 3x, 5x growth for the next three years, it's going to justify that valuation at some point. The bubble is merely that it's gotten ahead of itself, not the likelihood of growth in the future. Not saying it's worth its price, right, but there's absolute substance under the thumb. Now back to t...
Read more

The Mercurial Grok AI Assistant Understands & Speaks Indian Languages

Image
Grok , the AI model developed by Elon Musk's xAI, can understand when you type Indian languages like Hindi, Telugu, Odia or other Indian regional languages using English letters (like when you type 'namaste' instead of 'नमस्ते'), and it can respond by mixing English with those languages. Grok doesn't necessarily need the native script of these languages. It has natural language processing abilities that extend to multiple languages. This is great innovation because many people in India, especially in online communication, use transliteration. Grok can generate responses that combine English words and phrases with words and phrases from the regional language you used in your input. For example, if you ask a question using a mix of English and Telugu transliteration, Grok might respond with a sentence that includes both English and Telugu words. Check these Hindi, Telugu, Odiya samples - Grok, ab Hindi mein Grōk, ippuḍu telugulō Grok, Oḍiā re This way Grok is more...
Read more

40 Talks from the Google Web AI Summit 2025

Image
Front-end leaders share their experience on pushing the boundaries of Web AI and run machine learning models entirely client side in the browser via JavaScript to get privacy, lower costs, and lower latency. From traditional AI models to Generative AI such as large language models (LLMs) and diffusion models, discover the latest advances of Web AI in 2024 that are accelerated by technologies such as WebAssembly, WebGPU, and WebNN.
Read more