blogs.conchango.com

welcome to the conchango blogging site

Welcome to blogs.conchango.com Sign in | Join | Help

Claypole's World - The SQL Server Side

Concerning development of bespoke applications and database administration.

SQL Security Patch Build is CU6+ but not quite CU7

So as suspected when I installed the new Security patch released by Microsoft for SQL 2005 sp2 that I mentioned this morning my build number has indeed shot up to 3233.

This places me somewhere between CU6 and CU7. Build 9.00.3228 was CU6 and 9.00.3239 is CU7.

So just bear in mind that when you plop on your patch you are actually taking a number of other fixes through with you. Test...Test... Test...

If you are interested in seeing what published builds are out there I know of no better resource than sqlsecurity.com's version database which you can find here.

Cheers, JRJ

del.icio.us Tags: Security,SQL Server 2005,SQL Server,Sp2

Published 10 July 2008 11:40 by James.Rowland-Jones

Filed under: SQL Server 2005, sp2, SQL Server, Security

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

	Paul McMillan said: James Thanks for excellent post, does this mean (that as I have CU7) I do not need to apply this particlaur hotfix. I know or a fact it was NOT offered up to me by WindowsUpdate Paul July 11, 2008 13:42
	James.Rowland-Jones said: That's right Paul you should not need this fix for your SQL 2005 instance. Microsoft Build numbers are an ever incrementing number and by definition a higher build number contains the fixes and features of a lower build. As CU7's build number is higher than the security patch build number I think it's safe to say you already have the fix. Cheers, James July 11, 2008 13:46
	Chuck Hawkins said: Here are all the objects that were modified between build 3159 and 3233 (all in MSDB). Build 3159 was the last publicly available build. sp_add_jobschedule Stored Procedure sp_add_jobstep_internal Stored Procedure sp_attach_schedule Stored Procedure sp_delete_job Stored Procedure sp_delete_job_references Stored Procedure sp_delete_jobschedule Stored Procedure sp_delete_jobserver Stored Procedure sp_delete_schedule Stored Procedure sp_detach_schedule Stored Procedure sp_ExternalMailQueueListener Stored Procedure sp_get_composite_job_info Stored Procedure sp_help_jobhistory Stored Procedure sp_help_jobhistory_full Stored Procedure sp_help_jobhistory_full Stored Procedure sp_help_jobhistory_sem Stored Procedure sp_help_jobhistory_sem Stored Procedure sp_help_jobhistory_summary Stored Procedure sp_help_jobhistory_summary Stored Procedure sp_maintplan_delete_subplan Stored Procedure sp_maintplan_subplans_by_job Stored Procedure sp_maintplan_update_subplan Stored Procedure sp_maintplan_update_subplan_tsx Stored Procedure sp_ProcessResponse Stored Procedure sp_RunMailQuery Stored Procedure sp_send_dbmail Stored Procedure sp_sqlagent_has_server_access Stored Procedure sp_sqlagent_is_srvrolemember Stored Procedure sp_sqlagent_refresh_job Stored Procedure sp_sysmail_activate Stored Procedure sp_sysmail_activate Stored Procedure sp_update_jobschedule Stored Procedure sp_update_schedule Stored Procedure sp_validate_user Stored Procedure sp_validate_user Stored Procedure sp_verify_jobstep Stored Procedure sp_verify_schedule Stored Procedure sp_verify_subsystems Stored Procedure sysmail_delete_mailitems_sp Stored Procedure sysmail_delete_profile_sp Stored Procedure sysmail_update_account_sp Stored Procedure sysmail_event_log View sysmail_event_log View sysmaintplan_plans View July 11, 2008 19:48
	as<asA said: asdadasda July 22, 2008 19:51

Name (required)
Your URL (optional)
Comments (required)
Remember Me?
Submit

About James.Rowland-Jones

James is a Senior Technical Consultant for Conchango. He works primarily with SQL Server technologies in architecture, development and administration capacities. He also co-ordinates Conchango's SQL Server Community.

blogs.conchango.com

Claypole's World - The SQL Server Side

SQL Security Patch Build is CU6+ but not quite CU7

Comment Notification

Comments

Paul McMillan said:

James.Rowland-Jones said:

Chuck Hawkins said:

as<asA said:

Leave a Comment

About James.Rowland-Jones

This Blog

Syndication

Recent Posts

Tags

News

Archives