SQL 2005 Express, Standard etc.

[TechMerlin]

Hi All,

Is there a quick way to tell if a machine is using SQL 2005 express vs. Standard? I have to upgrade any Express machines due to the 4GB database restriction and just need a way to figure which machines need the upgrade.

Thanks

Mark Morton, MCITP, MCTS, MCSA, MCP, SNA, CCA, CCE

 

[hmckillop]

if you have access to a query window run
Select @@version

this tells you version right down to sp pack and hotfixes applied

http://support.microsoft.com/kb/321185

"I'm living so far beyond my income that we may almost be said to be living apart

 

[markros]

SELECT 
	SERVERPROPERTY('Edition') AS Edition,
	SERVERPROPERTY('ProductVersion') AS ProductVersion,
	SERVERPROPERTY('ProductLevel') AS ProductLevel

 

[TechMerlin]

Thank you gentlemen, this worked perfectly

Mark Morton CCA,MCITP,MCTS,MCSA,SNA,SERVER+