January 31, 2011 at 2:01 pm
Anybody know if applying SP4 should update an old resource database? Now, I just applied SP4 to a development box that was at Sql 2005 Enterprise 64-bit SP3 and the resource database still shows a date from December 2010, so apparently not touched by SP4. ?
January 31, 2011 at 2:15 pm
upgrades work by replacing the resource database. Got an SP3 one to compare it to?
the modified date on it won't be the date you ran your upgrade but the date MS 'created' it.
---------------------------------------------------------------------
January 31, 2011 at 2:27 pm
The resource database for one of our SP3 boxes is dated 2008. For the one just upgraded to SP4 it shows last month, and for our main production system which shows as SP3 it's dated back in 2005 -- seems pretty conclusive you can run without problems on an old resource database. I'm just hoping applying SP4 will fix our performance dashboard reports since the production one doesn't have this view: SYS.DM_EXEC_TEXT_QUERY_PLAN which came with SP2
January 31, 2011 at 2:28 pm
my SP3 installs show a modified date of 24/11/08.
December 2010 sounds right for SP4 though I haven't installed it yet.
---------------------------------------------------------------------
January 31, 2011 at 2:37 pm
Even though the prod system shows as SP3, the queries below show something else for the resource database.
--To determine the version number of the Resource database, use:
SELECT SERVERPROPERTY('ResourceVersion');
GO
--To determine when the Resource database was last updated, use:
SELECT SERVERPROPERTY('ResourceLastUpdateDateTime');
GO
--To access SQL definitions of system objects, use the OBJECT_DEFINITION function:
SELECT OBJECT_DEFINITION(OBJECT_ID('sys.objects'));
GO
output:
9.00.1399
2005-10-14 01:56:22.007
CREATE VIEW sys.objects AS
SELECT name, object_id, principal_id, schema_id, parent_object_id,
type, type_desc, create_date, modify_date,
is_ms_shipped, is_published, is_schema_published
FROM sys.objects$
January 31, 2011 at 2:53 pm
1399 is RTM, what makes you think its SP3?
---------------------------------------------------------------------
January 31, 2011 at 3:09 pm
When you run this:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
you get:
9.00.4262.00|SP3|Enterprise Edition (64-bit)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply