2005 SP2 - Pros & Cons ?

We are considering installing SP2 for 2005. Does anyone have any issues with
this service pack, or know of any good reasons not to install or to give
serious consideration to do so?
TIA
Michael MacGregor
Database Architect
Just make sure you are prepared to re-create maintenance plans, because in
addition to fixing some issues, SP2 created a bunch of new ones. And you'll
want to get the post-SP2 cumulative update before you do that.
http://support.microsoft.com/kb/936305
Aaron Bertrand
SQL Server MVP
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:%236$5V0tyHHA.1204@.TK2MSFTNGP03.phx.gbl...
> We are considering installing SP2 for 2005. Does anyone have any issues
> with this service pack, or know of any good reasons not to install or to
> give serious consideration to do so?
> TIA
> Michael MacGregor
> Database Architect
>

2005 SP2 - Pros & Cons ?

We are considering installing SP2 for 2005. Does anyone have any issues with
this service pack, or know of any good reasons not to install or to give
serious consideration to do so?
TIA
Michael MacGregor
Database ArchitectJust make sure you are prepared to re-create maintenance plans, because in
addition to fixing some issues, SP2 created a bunch of new ones. And you'll
want to get the post-SP2 cumulative update before you do that.
http://support.microsoft.com/kb/936305
Aaron Bertrand
SQL Server MVP
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:%236$5V0tyHHA.1204@.TK2MSFTNGP03.phx.gbl...
> We are considering installing SP2 for 2005. Does anyone have any issues
> with this service pack, or know of any good reasons not to install or to
> give serious consideration to do so?
> TIA
> Michael MacGregor
> Database Architect
>

2005 SP2 - Pros & Cons ?

We are considering installing SP2 for 2005. Does anyone have any issues with
this service pack, or know of any good reasons not to install or to give
serious consideration to do so?
TIA
Michael MacGregor
Database ArchitectJust make sure you are prepared to re-create maintenance plans, because in
addition to fixing some issues, SP2 created a bunch of new ones. And you'll
want to get the post-SP2 cumulative update before you do that.
http://support.microsoft.com/kb/936305
--
Aaron Bertrand
SQL Server MVP
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:%236$5V0tyHHA.1204@.TK2MSFTNGP03.phx.gbl...
> We are considering installing SP2 for 2005. Does anyone have any issues
> with this service pack, or know of any good reasons not to install or to
> give serious consideration to do so?
> TIA
> Michael MacGregor
> Database Architect
>

2005 Service Pack 2 Release Version schedule

Greetings,
I'm looking for a scheduled release date for Service Pack 2 for SQL Server
2005.
Thanks,
Mike Hayes
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
There is no such thing.
The release date will be largely based, I would guess, on how much
[negative] feedback is obtained from the SP2 CTP. Which you can download,
kick the tires, and report any problems at connect.microsoft.com:
http://www.microsoft.com/sql/ctp.mspx
Other than that, as Tibor mentioned, we can guess, but there are no
announced dates, because it is not based on a date, but rather WHEN IT'S
READY.
A
|||At the keynote at PASS, Paul Flessner I believe stated that SP2 would likely
be out in "early Q1." Of course that is not an official announcement, and
it really could mean anytime between January 1st and March 31st. Or later,
if it's simply not ready.
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes

2005 Service Pack 2 Release Version schedule

Greetings,
I'm looking for a scheduled release date for Service Pack 2 for SQL Server
2005.
Thanks,
Mike HayesMS do not decide on such dates. The official response is "when it is ready".
It is in RC2 now, so
based on that, we can *guess* that it might be 1.5-2 months away, but nobody
knows.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes|||> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
There is no such thing.
The release date will be largely based, I would guess, on how much
[negative] feedback is obtained from the SP2 CTP. Which you can downloa
d,
kick the tires, and report any problems at connect.microsoft.com:
http://www.microsoft.com/sql/ctp.mspx
Other than that, as Tibor mentioned, we can guess, but there are no
announced dates, because it is not based on a date, but rather WHEN IT'S
READY.
A|||At the keynote at PASS, Paul Flessner I believe stated that SP2 would likely
be out in "early Q1." Of course that is not an official announcement, and
it really could mean anytime between January 1st and March 31st. Or later,
if it's simply not ready.
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes

2005 Service Pack 2 Release Version schedule

Greetings,
I'm looking for a scheduled release date for Service Pack 2 for SQL Server
2005.
Thanks,
Mike HayesMS do not decide on such dates. The official response is "when it is ready". It is in RC2 now, so
based on that, we can *guess* that it might be 1.5-2 months away, but nobody knows.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes|||> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
There is no such thing.
The release date will be largely based, I would guess, on how much
[negative] feedback is obtained from the SP2 CTP. Which you can download,
kick the tires, and report any problems at connect.microsoft.com:
http://www.microsoft.com/sql/ctp.mspx
Other than that, as Tibor mentioned, we can guess, but there are no
announced dates, because it is not based on a date, but rather WHEN IT'S
READY.
A|||At the keynote at PASS, Paul Flessner I believe stated that SP2 would likely
be out in "early Q1." Of course that is not an official announcement, and
it really could mean anytime between January 1st and March 31st. Or later,
if it's simply not ready.
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes

2003 Service Pack 1

Hello,
Does anyone know if there are any problems with this and SQL Server 2000 ?
Thanks
P
I applied it to one server without any issues.
Keith
"Patricia" <Patricia@.discussions.microsoft.com> wrote in message
news:BB8BA402-701F-4761-98A6-9024F1D2AA08@.microsoft.com...
> Hello,
> Does anyone know if there are any problems with this and SQL Server 2000 ?
> Thanks
> P
|||We are running many prod servers with no problems either...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Patricia" <Patricia@.discussions.microsoft.com> wrote in message
news:BB8BA402-701F-4761-98A6-9024F1D2AA08@.microsoft.com...
> Hello,
> Does anyone know if there are any problems with this and SQL Server 2000 ?
> Thanks
> P
|||Thanks guys
"Patricia" wrote:

> Hello,
> Does anyone know if there are any problems with this and SQL Server 2000 ?
> Thanks
> P

2003 Service Pack 1

Hello,
Does anyone know if there are any problems with this and SQL Server 2000 ?
Thanks
PI applied it to one server without any issues.
--
Keith
"Patricia" <Patricia@.discussions.microsoft.com> wrote in message
news:BB8BA402-701F-4761-98A6-9024F1D2AA08@.microsoft.com...
> Hello,
> Does anyone know if there are any problems with this and SQL Server 2000 ?
> Thanks
> P|||We are running many prod servers with no problems either...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Patricia" <Patricia@.discussions.microsoft.com> wrote in message
news:BB8BA402-701F-4761-98A6-9024F1D2AA08@.microsoft.com...
> Hello,
> Does anyone know if there are any problems with this and SQL Server 2000 ?
> Thanks
> P

2003 Service Pack 1

Hello,
Does anyone know if there are any problems with this and SQL Server 2000 ?
Thanks
PI applied it to one server without any issues.
Keith
"Patricia" <Patricia@.discussions.microsoft.com> wrote in message
news:BB8BA402-701F-4761-98A6-9024F1D2AA08@.microsoft.com...
> Hello,
> Does anyone know if there are any problems with this and SQL Server 2000 ?
> Thanks
> P|||We are running many prod servers with no problems either...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Patricia" <Patricia@.discussions.microsoft.com> wrote in message
news:BB8BA402-701F-4761-98A6-9024F1D2AA08@.microsoft.com...
> Hello,
> Does anyone know if there are any problems with this and SQL Server 2000 ?
> Thanks
> P|||Thanks guys
"Patricia" wrote:

> Hello,
> Does anyone know if there are any problems with this and SQL Server 2000 ?
> Thanks
> P