MSMVPS.COM

The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.

All Tags » SQL Server » Service Pack » edition » collation (RSS)

Browse Site by Tags

Showing related tags and posts accross the entire site.

TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?

Use the following TSQL SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName') InstanceName, SERVERPROPERTY('IsClustered') IsClustered, SERVERPROPERTY('IsFullTextInstalled'...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 12-21-2007
Filed under: sql server, version, edition, license, service pack, tsql, best practice, collation, server property, engine

Page 1 of 1 (1 items)

Copyright © is the original authors. Blog site is an independent site not sponsored by Microsoft. The Yoda blog server and the Brianna SQL server would like to thank www.ownwebnow.com and www.exchangedefender.com. They wouldn't be here and broadcasting without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Browse Site by Tags

TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?