We have SQL Server 2005 SP1 currently and VS 2005. We're planning on installing SP4 for Sql Server 2005.
Question: Are there any specific requirements for this install or known negative effects that we should know about?
Thank you.
We have SQL Server 2005 SP1 currently and VS 2005. We're planning on installing SP4 for Sql Server 2005.
Question: Are there any specific requirements for this install or known negative effects that we should know about?
Thank you.
You should "smoke test" in a testing environment whenever possible but, in general, SQL Server service packs have not been the cause of great difficulties in my experience (especially not with SQL Server 2005).
In response to your comment: SQL Service Service Packs are not "additive"-- that is you can install Service Pack 4 over any existing prior version without needing to load "prerequisites".