Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Which Version of 2008 is Installed?

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2010-10-28 : 17:15:06
Hello again,

After my 2008 installtion completes, I want to verify that the 64 bit/x64 version was installed.

For 2005 I run this:
select getdate(),
cast(serverproperty('machinename') as varchar(20)) 'Server',
cast(serverproperty('productversion') as varchar(1)) 'Version',
cast(serverproperty('productlevel') as varchar(20)) 'SP',
cast(serverproperty('edition') as varchar(40)) 'Edition',
cast(serverproperty('IsClustered') as varchar(1)) 'Is Clustered?',
cast(serverproperty('LicenseType') as varchar(40)) 'LicenseType';

Will this work for 2008 instances as well?

Thanks, John

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-28 : 17:29:17
yes
Go to Top of Page
   

- Advertisement -