Tuesday, March 20, 2012
Patching WMSDE with SP4
I am trying to apply MSDE SP4 to the WSUS instance and it returns an error
message stating that SQL server is not installed.
Thanks in advance for your help.
Hi
You may want to print the exact error message, but any instance of SQL
Server should be patchable with the correct patch file.
John
"Buckeye" <Buckeye@.discussions.microsoft.com> wrote in message
news:94A93D9E-A8A8-481F-B1D8-12C9EA0E79E7@.microsoft.com...
> Can anyone tell me whether WMSDE (which installs with WSUS) can be
> patched?
> I am trying to apply MSDE SP4 to the WSUS instance and it returns an error
> message stating that SQL server is not installed.
> Thanks in advance for your help.
Patching WMSDE with SP4
I am trying to apply MSDE SP4 to the WSUS instance and it returns an error
message stating that SQL server is not installed.
Thanks in advance for your help.Hi
You may want to print the exact error message, but any instance of SQL
Server should be patchable with the correct patch file.
John
"Buckeye" <Buckeye@.discussions.microsoft.com> wrote in message
news:94A93D9E-A8A8-481F-B1D8-12C9EA0E79E7@.microsoft.com...
> Can anyone tell me whether WMSDE (which installs with WSUS) can be
> patched?
> I am trying to apply MSDE SP4 to the WSUS instance and it returns an error
> message stating that SQL server is not installed.
> Thanks in advance for your help.
Patching WMSDE with SP4
I am trying to apply MSDE SP4 to the WSUS instance and it returns an error
message stating that SQL server is not installed.
Thanks in advance for your help.Hi
You may want to print the exact error message, but any instance of SQL
Server should be patchable with the correct patch file.
John
"Buckeye" <Buckeye@.discussions.microsoft.com> wrote in message
news:94A93D9E-A8A8-481F-B1D8-12C9EA0E79E7@.microsoft.com...
> Can anyone tell me whether WMSDE (which installs with WSUS) can be
> patched?
> I am trying to apply MSDE SP4 to the WSUS instance and it returns an error
> message stating that SQL server is not installed.
> Thanks in advance for your help.
Patching WMSDE db's
Working on sql sp4 patching, we have one db that is an MSDE hybrid..WMSDE,
which is what ships with WSUS. If installed as the default on a Windows 200
3
server what sql version is it at, and has anyone had any experience with
patching this with MSDE SP4?
thxExperiencing the same issue on a WSUS server. ISS Internet Scanner says it
needs SQL SP4, but SP4 will not install. Anyone know if there is a version
of SP4 specifically designed for WMSDE? or whether or not WMSDE can be patc
hed at all?
**************
quote:
Originally posted by bill_the_cat
Howdy,
Working on sql sp4 patching, we have one db that is an MSDE hybrid..WMSDE,
which is what ships with WSUS. If installed as the default on a Windows 200
3
server what sql version is it at, and has anyone had any experience with
patching this with MSDE SP4?
thx
Patching sqp2k sp3a
How can I know (and from where can I download) which patches have I to
install on my box?
Any help appreciated.
Regards.
Fabrizio Maccarrone
YAMSSQLU
(Yet Another MSSQL User)
Hi,
Infact sp3a is the latest service pack available for SQL 2000.
How can I know (and from where can I download) which patches have I to
install on my box?
Have a look into the microsoft site once ina week to get the information.
http://www.microsoft.com/sql/
Thanks
Hari
MCDBA
"Fabrizio Maccarrone" <fabrizio (at) 7mates (punto) com> wrote in message
news:uUDALNcXEHA.3988@.tk2msftngp13.phx.gbl...
> I have sql server 2000 sp3a installed.
> How can I know (and from where can I download) which patches have I to
> install on my box?
> Any help appreciated.
> Regards.
> --
> Fabrizio Maccarrone
> --
> YAMSSQLU
> (Yet Another MSSQL User)
>
|||Hi,
Infact sp3a is the latest service pack available for SQL 2000.
How can I know (and from where can I download) which patches have I to
install on my box?
Have a look into the microsoft site once ina week to get the information.
http://www.microsoft.com/sql/
Thanks
Hari
MCDBA
"Fabrizio Maccarrone" <fabrizio (at) 7mates (punto) com> wrote in message
news:uUDALNcXEHA.3988@.tk2msftngp13.phx.gbl...
> I have sql server 2000 sp3a installed.
> How can I know (and from where can I download) which patches have I to
> install on my box?
> Any help appreciated.
> Regards.
> --
> Fabrizio Maccarrone
> --
> YAMSSQLU
> (Yet Another MSSQL User)
>
Patching SQLServer/MSDE
We are developing a desktop application that will use an MSDE database. The
data in the DB we deploy cannot be read by users, or administrators of the b
ox or other SQL Server admins. To accomplish this, we have learned we would
have to install a separate
instance of SQLServer/MSDE on the user's PC (or, alternately, encrypt the da
tabase).
The downside to a separate instance is we would be responsible to apply any
SQL Server patches to our instance. Our software is given to our customers,
and we have no control over their machines, so we will have to issue servic
e patches for our software
that contain the SQL Server patches as they come out.
My question is this: Obviously, it will be difficult for us to get patches o
f our software out there immediately after each SQL Server patch is released
my Microsoft. Are there threats that SQL Server remedy that can possibly ha
ve an adverse effect on sof
tware/hardware outside of the our database that is using the SQL Server inst
ance? I'm wondering about our liability if say, we release our version of a
patch 1-2 months after Microsoft releases their patch. I know our database
may be threatened, but is
there the possibility the user's machines/network would also be threatened i
f certain patches are not installed in a timely matter? I understand how th
is would be a major issue if we were talking about patches to IIS, but not
so sure about SQL Server.
Any thoughts on this are greatly appreciated.
Thanks!MSDE can be configured to listen only on Shared Memory. This will limit
your exposure from
external machines. So, other machines won't be able to connect to your
instance of MSDE, since
it's not listening on TCP or Named Pipes. Only local connections would
succeed.
MBSA 1.2 can be used to scan the local machine to see if it needs any SQL
related security fixes.
This could be documented in your application notes.
http://www.microsoft.com/technet/se...s/mbsahome.mspx
You can also find out Best Practices on the web ;
http://www.microsoft.com/technet/pr...n/sp3sec00.mspx
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Patching SqlRun_Sql.msi not successful
Hi all,
when I tried to integrate SP1 into my install media (32bit Developer Edition) by using
msiexec /i sqlrun_sql.msi shortfilename=true /p sqlrun_sql.msp
using the msp from an extracted SP1 full web download I ended up with a modified msi file. But installing from this one I received an error:
"sysdbupg.sql.<some_guid> was not found in Sql.CAB"
Any ideas how to fix that?
With best regards,
Artus
Hey Artus, what is it specifically that you're trying to integrate? Are you able to change your install cmd to call the SP1 exe instead? Are you confined to call the msp's directly? This gets a bit sticky and we'd prefer to stay with the exe if possible.
Thanks,
Sam Lester (MSFT)
Hi Sam,
for the university I am at we are looking for a solution to deploy SQL Server 2005 to several dozens of computers. It is though not feasible for us to get someone manually installing SQL Server to each computer that is why we are
(1) looking for a program to write an appropriate MST file [any hints appreciated] to deploy custom installation for our AD forest
(2) integrating SP1 and the hotfix rollup for SP1 into the install media *
And for (2) I extracted the SP1 web download, searched for the MSPs and now try to integrate them into the corresponding MSIs.
With kind regards,
Artus
*.) We don't get any of the two updates delivered by Microsoft Update opposite to what we expected when we migrated to Microsoft Update. If WSUS will deliver both the SP1 and the rollup we were fine with that, too
|||Still any help appreciated :-)|||Running the MSP directly to upgrade to SP1 is not supported. You should look at launching the hotfix.exe using the unattended command-line flags, such as /quiet and /allinstances.
SQL Server SP1 has just been published to Microsoft Update so you can also obatin the update from there.
Peter
Patching SQL server in the field?
patch our SQL servers in the field. I've search high and low and cannot find
any solid docs on if this is possible? supported or recommended? or how to d
o
it at all. I built a new test Software update package and it had only a hand
full of security updates for SQL. So i guess my questions are
1) Is this possible and are there documents to support it?
2) SQL service packs a built very differently then normal patches and
updates. Because of this is it not advisable to repackage them for SMS?
Thanks in Advance!!
DobolinaIt's possible with SQL Server 2000, but it uses some old installshield
technology so that you need to capture an answer file and use that (and be
pretty sure that your choises will work on each server where it will be
applied). I had some minor issues with this when I upgraded some 70-80
servers a couple of years ago.
With SQL 2005 Microsoft moved to Windows Installer, and it seems to be much
easier to upgrade. Last week I created an upgrade from SQL 2000 to SQL 2005
with SP2 that I'm able to run silently from the SMS client.
/Rune
"Bob Dobolina" <Bob Dobolina@.discussions.microsoft.com> wrote in message
news:215C80C3-06DF-4B40-A82A-37CF2877504D@.microsoft.com...
> I've been working with the DBAs to come up with a plan to Service pack and
> patch our SQL servers in the field. I've search high and low and cannot
> find
> any solid docs on if this is possible? supported or recommended? or how to
> do
> it at all. I built a new test Software update package and it had only a
> hand
> full of security updates for SQL. So i guess my questions are
> 1) Is this possible and are there documents to support it?
> 2) SQL service packs a built very differently then normal patches and
> updates. Because of this is it not advisable to repackage them for SMS?
> Thanks in Advance!!
> Dobolina|||Thanks Rune,
I too noticed the SP4 exe extracts into an old school directory structure.
Lucky we have a packaging wizard. I'll sick him on the task.
again, thanks!
"Rune Norberg" wrote:
> It's possible with SQL Server 2000, but it uses some old installshield
> technology so that you need to capture an answer file and use that (and be
> pretty sure that your choises will work on each server where it will be
> applied). I had some minor issues with this when I upgraded some 70-80
> servers a couple of years ago.
> With SQL 2005 Microsoft moved to Windows Installer, and it seems to be muc
h
> easier to upgrade. Last week I created an upgrade from SQL 2000 to SQL 200
5
> with SP2 that I'm able to run silently from the SMS client.
> /Rune
> "Bob Dobolina" <Bob Dobolina@.discussions.microsoft.com> wrote in message
> news:215C80C3-06DF-4B40-A82A-37CF2877504D@.microsoft.com...
>|||Hmmm, are you trying to do a repackage of this servicepack? I doubt that you
will get a good repacked solution as there are several *.sql scripts that is
run against to system databases to upgrade them.
/Rune
"Bob Dobolina" <BobDobolina@.discussions.microsoft.com> wrote in message
news:93931A57-7C13-4C22-88E2-9C7527D5EEC8@.microsoft.com...[vbcol=seagreen]
> Thanks Rune,
> I too noticed the SP4 exe extracts into an old school directory structure.
> Lucky we have a packaging wizard. I'll sick him on the task.
> again, thanks!
> "Rune Norberg" wrote:
>
Patching SQL in a Clustered Environment
Cluster setup. Will I run into any issues when attempting
to patch SQL with SQL SP3? Are there any issues I should
be aware of when patching the SQL cluster or any
prerequisite patches that need to be applied before
patching SQL in a cluster?
This is a rather open ended question. Are you talking about a specific
patch or just patches in general
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I am speaking of a general Serivce Pack 3a update. When dealing with virtual servers, are there any issues when applying the SP3a update?
rp
-- Rand Boyd [MSFT] wrote: --
This is a rather open ended question. Are you talking about a specific
patch or just patches in general
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Not really anything special. Make sure all nodes are online and are capable
of hosting the service. You will need to run the service pack from the node
hosting the particular instance you wish to update. If you have more than
one instance, you will need to apply the Service Pack to each instance
independantly. It is possible to run different instances at different
service pack and hotfix levels without a problem. Of course all instances
on a particular host will run against the same level MDAC installation. If
you run into any issues, you know where to find help.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Bob" <anonymous@.discussions.microsoft.com> wrote in message
news:02068577-4EB9-472E-A36E-D21EF109FC91@.microsoft.com...
> I am speaking of a general Serivce Pack 3a update. When dealing with
virtual servers, are there any issues when applying the SP3a update?
> rp
> -- Rand Boyd [MSFT] wrote: --
> This is a rather open ended question. Are you talking about a
specific
> patch or just patches in general
> Rand
> This posting is provided "as is" with no warranties and confers no
rights.
>
|||Before applying any service pack, always review the readme. For sp3a on a
cluster, see:
811168 INF: SQL Server 2000 Service Pack 3 or Service Pack 3a
Pre-Installation
http://support.microsoft.com/?id=811168
And you should strongly consider applying the MS03-031 security rollup as
well.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Cindy. I didn't know you had joined Microsoft.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
Patching sp2k sp3a
How can I know (and from where can I download) which patches have I to
install on my box?
Any help appreciated.
Regards.
Fabrizio Maccarrone
--
YAMSSQLU
(Yet Another MSSQL User)Fabrizio,
There are many hotfixes for SQL2000 SP3A but you would have to at least
contact MS to get them and then they would probably charge you unless you
have the problem that they fix. There has been 1 security patch, MS03-031,
since SP3A came out but you can get this post MS03-031 patch with a download
from here
http://support.microsoft.com/defaul...1&Product=sql2k
Chris Wood
Alberta Department of Energy
CANADA
"Fabrizio Maccarrone" <fabrizio (at) 7mates (punto) com> wrote in message
news:eTRl$McXEHA.3596@.tk2msftngp13.phx.gbl...
> I have sql server 2000 sp3a installed.
> How can I know (and from where can I download) which patches have I to
> install on my box?
> Any help appreciated.
> Regards.
> --
> Fabrizio Maccarrone
> --
> YAMSSQLU
> (Yet Another MSSQL User)
>
Patching sp2k sp3a
How can I know (and from where can I download) which patches have I to
install on my box?
Any help appreciated.
Regards.
--
Fabrizio Maccarrone
--
YAMSSQLU
(Yet Another MSSQL User)Fabrizio,
There are many hotfixes for SQL2000 SP3A but you would have to at least
contact MS to get them and then they would probably charge you unless you
have the problem that they fix. There has been 1 security patch, MS03-031,
since SP3A came out but you can get this post MS03-031 patch with a download
from here
http://support.microsoft.com/default.aspx?scid=kb;en-us;826161&Product=sql2k
Chris Wood
Alberta Department of Energy
CANADA
"Fabrizio Maccarrone" <fabrizio (at) 7mates (punto) com> wrote in message
news:eTRl$McXEHA.3596@.tk2msftngp13.phx.gbl...
> I have sql server 2000 sp3a installed.
> How can I know (and from where can I download) which patches have I to
> install on my box?
> Any help appreciated.
> Regards.
> --
> Fabrizio Maccarrone
> --
> YAMSSQLU
> (Yet Another MSSQL User)
>
Patching sp2k sp3a
How can I know (and from where can I download) which patches have I to
install on my box?
Any help appreciated.
Regards.
Fabrizio Maccarrone
YAMSSQLU
(Yet Another MSSQL User)
Fabrizio,
There are many hotfixes for SQL2000 SP3A but you would have to at least
contact MS to get them and then they would probably charge you unless you
have the problem that they fix. There has been 1 security patch, MS03-031,
since SP3A came out but you can get this post MS03-031 patch with a download
from here
http://support.microsoft.com/default...&Product=sql2k
Chris Wood
Alberta Department of Energy
CANADA
"Fabrizio Maccarrone" <fabrizio (at) 7mates (punto) com> wrote in message
news:eTRl$McXEHA.3596@.tk2msftngp13.phx.gbl...
> I have sql server 2000 sp3a installed.
> How can I know (and from where can I download) which patches have I to
> install on my box?
> Any help appreciated.
> Regards.
> --
> Fabrizio Maccarrone
> --
> YAMSSQLU
> (Yet Another MSSQL User)
>
|||Fabrizio,
There are many hotfixes for SQL2000 SP3A but you would have to at least
contact MS to get them and then they would probably charge you unless you
have the problem that they fix. There has been 1 security patch, MS03-031,
since SP3A came out but you can get this post MS03-031 patch with a download
from here
http://support.microsoft.com/default...&Product=sql2k
Chris Wood
Alberta Department of Energy
CANADA
"Fabrizio Maccarrone" <fabrizio (at) 7mates (punto) com> wrote in message
news:eTRl$McXEHA.3596@.tk2msftngp13.phx.gbl...
> I have sql server 2000 sp3a installed.
> How can I know (and from where can I download) which patches have I to
> install on my box?
> Any help appreciated.
> Regards.
> --
> Fabrizio Maccarrone
> --
> YAMSSQLU
> (Yet Another MSSQL User)
>
Patching for W2k3 SP1 server w/SQL Server 2005
Is the correct procedure for SUS patches to a server running SQL Server 2005, to set the client to download only and then manually shutdown SQL Server, apply patches, reboot, and restart SQL Server?
Do SQL Server 2005 patches download through SUS or is it manual SP only, except for hotfixes?
Thanks, Tom
I don't have much experience with SUS, but the hotfix patches will take care of the services for you. SP2, which has publicly released quite yet, shows a list of processes in use to allow you to shut them down before patching. This will eliminate the reboot need.
Thanks,
Sam Lester (MSFT)
patching a windows server 2003 cluster
I have an active-active SQL 2000 Cluster running on Server 2003. Both nodes
have a vanilla 2003 OS on them. I tried upgrading each nodes to a new custom
build (hotfixes, security templates, etc) and it broke both nodes after I
patched the first one. Any suggestions?
Most likely you broke a driver for your shared storage. Check with your
hardware vendor for cluster-certified drivers for the SCSI cards or HBAs.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"jay d" <jayd@.discussions.microsoft.com> wrote in message
news:37204249-71C3-41A3-BF26-EA6463E3D662@.microsoft.com...
> Hi,
> I have an active-active SQL 2000 Cluster running on Server 2003. Both
> nodes
> have a vanilla 2003 OS on them. I tried upgrading each nodes to a new
> custom
> build (hotfixes, security templates, etc) and it broke both nodes after I
> patched the first one. Any suggestions?
|||Thanks. Any idea if there is a best practices guide for fail over cluster
maintenance?
"Geoff N. Hiten" wrote:
> Most likely you broke a driver for your shared storage. Check with your
> hardware vendor for cluster-certified drivers for the SCSI cards or HBAs.
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "jay d" <jayd@.discussions.microsoft.com> wrote in message
> news:37204249-71C3-41A3-BF26-EA6463E3D662@.microsoft.com...
>
>
|||Thanks. Any idea if there is a best practices guide for fail over cluster
maintenance?
Jay
"Geoff N. Hiten" wrote:
> Most likely you broke a driver for your shared storage. Check with your
> hardware vendor for cluster-certified drivers for the SCSI cards or HBAs.
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "jay d" <jayd@.discussions.microsoft.com> wrote in message
> news:37204249-71C3-41A3-BF26-EA6463E3D662@.microsoft.com...
>
>
|||Try these. Although a good document throughout, there are two sections
worth noting in your case, Maintenance and Troubleshooting.
SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
Maintaining a SQL Server 2000 Failover Cluster
http://www.microsoft.com/technet/pro...clus.mspx#EIAA
Troubleshooting SQL Server 2000 Failover Clusters
http://www.microsoft.com/technet/pro...clus.mspx#EHAA
Also, for "rolling upgrades," these are worth a look.
Rolling Upgrades
http://www.microsoft.com/technet/pro...ff977ef91.mspx
Restrictions on rolling upgrades
http://www.microsoft.com/technet/pro...f300fcd61.mspx
Good luck.
Sincerely,
Anthony Thomas
"jay d" <jayd@.discussions.microsoft.com> wrote in message
news:C2404898-825C-4841-B2E4-9815FF0A9378@.microsoft.com...
Thanks. Any idea if there is a best practices guide for fail over cluster
maintenance?
"Geoff N. Hiten" wrote:
[vbcol=seagreen]
> Most likely you broke a driver for your shared storage. Check with your
> hardware vendor for cluster-certified drivers for the SCSI cards or HBAs.
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "jay d" <jayd@.discussions.microsoft.com> wrote in message
> news:37204249-71C3-41A3-BF26-EA6463E3D662@.microsoft.com...
I
>
>
Patching 64-bit SQL Server versions
the 64-bit and 32-bit versions have the same build numbers for any given
hotfix?
ChipYes.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Chip Andrews" <null@.null.com> wrote in message
news:e%23qCl5mLGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Couldn't find an answer to this anywhere: When patching SQL Servers, do
> the 64-bit and 32-bit versions have the same build numbers for any given
> hotfix?
> Chip
patching
out over time? What about Hot Fixes? Is Microsoft the only sources of
patches? Should I test the patch on a demo server before I place it in
production or should I just trust Microsoft?Hi
A SP is a fully end to end tested release that implements fixes and
enhancements to the base product. SP's are cumulative (then contain all
prior SP's fixes plus more).
A Security patch is a hotfix that addresses high priority fixes that if not
applied, could lead to compromised security.
A Hotfix is an update, issued to fix a specific problem that somebody had
encountered and Microsoft needs to fix as it could affect other users. A
Hotfix has limited support and does not have the massive amount of
regression testing as a Service Pack would as it is not possible in the
short time frames needed.
NEVER get a hotfix/SP/Security pack from any other source than Microsoft.
Microsoft never e-mails files either. There is always a link to their site
from where you can download it. You never know who has tampered with the
files if you don't get them yourself from MS.
With any release, always put it on test servers before production ones.
Functionality can change or behavior you were used to could be altered in a
way that your applications were not expecting.
www.microsoft.com/sql
www.microsoft.com/security
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:FECD7708-9C36-4810-9EF8-D011ADB6B021@.microsoft.com...
> What is the differnce between a Service Pack and Security Patches that
come
> out over time? What about Hot Fixes? Is Microsoft the only sources of
> patches? Should I test the patch on a demo server before I place it in
> production or should I just trust Microsoft?|||Hello Mike,
thanks for the answer. I am getting flack for wanting to test Service Packs
before they go into production.
Rich
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> A SP is a fully end to end tested release that implements fixes and
> enhancements to the base product. SP's are cumulative (then contain all
> prior SP's fixes plus more).
> A Security patch is a hotfix that addresses high priority fixes that if no
t
> applied, could lead to compromised security.
> A Hotfix is an update, issued to fix a specific problem that somebody had
> encountered and Microsoft needs to fix as it could affect other users. A
> Hotfix has limited support and does not have the massive amount of
> regression testing as a Service Pack would as it is not possible in the
> short time frames needed.
> NEVER get a hotfix/SP/Security pack from any other source than Microsoft.
> Microsoft never e-mails files either. There is always a link to their site
> from where you can download it. You never know who has tampered with the
> files if you don't get them yourself from MS.
> With any release, always put it on test servers before production ones.
> Functionality can change or behavior you were used to could be altered in
a
> way that your applications were not expecting.
> www.microsoft.com/sql
> www.microsoft.com/security
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:FECD7708-9C36-4810-9EF8-D011ADB6B021@.microsoft.com...
> come
>
>|||Hi
SP4 will break applications if they use XP functions that access the
registry. How much fun will you have if your app uses it and it dies because
of this?
If they don't accept that you need to test compatibility, then maybe you are
working for the wrong company.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:E9805C2D-3522-4194-BCB4-58307D1E8422@.microsoft.com...
> Hello Mike,
> thanks for the answer. I am getting flack for wanting to test Service
Packs[vbcol=seagreen]
> before they go into production.
> Rich
> "Mike Epprecht (SQL MVP)" wrote:
>
not[vbcol=seagreen]
had[vbcol=seagreen]
Microsoft.[vbcol=seagreen]
site[vbcol=seagreen]
in a[vbcol=seagreen]
of[vbcol=seagreen]
in[vbcol=seagreen]|||Always test service packs before putting them into production. Although
service packs go through more testing than hotfixes there are so many
different environments out there that unless you test it in your specific
environment you can't be sure you're not going to hit an issue. Certainly in
our environment we have come across some very weird bugs just because of how
we have our servers configured (weirdest one yet was down to having an
affinity mask that was a multiple of 7 <g> )
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:E9805C2D-3522-4194-BCB4-58307D1E8422@.microsoft.com...[vbcol=seagreen]
> Hello Mike,
> thanks for the answer. I am getting flack for wanting to test Service
> Packs
> before they go into production.
> Rich
> "Mike Epprecht (SQL MVP)" wrote:
>