SQL server 2008 SP2

Last Post 07 Nov 2011 06:23 AM by dbandee. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
amossql
New Member
New Member

--
10 Dec 2010 06:55 AM

After I installed service pack 2 I did not see and version changes. The installation completed with out any errors and reboot the server. Shouldn't there be a version change?

rm
New Member
New Member

--
10 Dec 2010 08:33 AM
Can you post result of 'select @@version' here?
dbandee
New Member
New Member

--
07 Nov 2011 06:23 AM

always record serever state before and after any hfixes or updated/upgrades
i use

set nocount on
SELECT 
SERVERPROPERTY('ServerName') as ServerName, --cast(SERVERPROPERTY('ServerName') as varchar(47))
@@Servername as ServerName2,
SERVERPROPERTY('MachineName') as MachineName,
SERVERPROPERTY('InstanceName') as InstanceName,
SERVERPROPERTY('productversion') as Version,
SERVERPROPERTY ('productlevel') as Release,
SERVERPROPERTY ('edition') as Edition

GO

exec xp_msver 'ProductName', 'ProductVersion', 'Language', 'Platform', 'WindowsVersion',
'PhysicalMemory', 'ProcessorCount'

GO
--get server collation
sp_helpsortv

I ave it as txt file and then use file compare to see diff. hope this helps

You are not authorized to post a reply.

Acceptable Use Policy