Browse by Tags

SQL Server 2008 installation when Visual Studio 2008 is/isn't present?

Published 11 August 8 3:1 AM | SSQA.net

In continuation to the SQL2008-InstallationVows on Windows Server 2008 there was a brief notes on pre-requisite of Visual Studio 2008 Service Pack when you are trying to install the SQL setup. The release notes were bit confusing that you have got with...

Filed under: sql server, release, version, installation, service pack, visual studio, issues, problems

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

Published 21 December 7 3:34 AM | SSQA.net

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

Filed under: sql server, version, edition, license, service pack, tsql, best practice, collation, server property, engine