Sorry It is on SQL2k5

-----Original Message-----
From: Bellizzi Christopher Joseph
[mailto:mssqldba-ezmlmshield-x63598654.[Email address protected]
Sent: Friday, December 28, 2007 10:13 AM
To: LazyDBA Discussion
Subject: RE: Restrictions on Alter Database

I guess my first question is why your installing sp2 and not sp4?



PAYCHEX

Christopher Bellizzi

Information Technology * Database Administration

675 Basket Road * Webster, New York 14580

(585) 216-0670 * [Email address protected]





-----Original Message-----

From: Shan

[mailto:mssqldba-ezmlmshield-x42388537.[Email address protected]

Sent: Friday, December 28, 2007 12:22 PM

To: LazyDBA Discussion

Subject: Restrictions on Alter Database



Hi Guyz







it is taken from SQL2K SP2 readme.txt. Anyone have idea what to do to

implement this ?



Our sp2 is failing. we suspect the above problem and researching it.we

are running on default instance of SQL2K on win2003 ent sp2







"When you apply SP2, Setup upgrades system databases. If you have

implemented restrictions on the ALTER DATABASE syntax, this upgrade may

fail. Restrictions to ALTER DATABASE may include the following:







Explicitly denying the ALTER DATABASE statement.











A data definition language (DDL) trigger on ALTER DATABASE that rolls

back the transaction containing the ALTER DATABASE statement.











If you have restrictions on ALTER DATABASE, and Setup fails to upgrade

system databases to SP2, you must disable these restrictions and then

re-run Setup."







thanks in advance.











---------------------------------------------------------------------

TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY

To post a dba job: http://jobs.lazydba.com

To subscribe : http://www.LazyDBA.com

To unsubscribe: http://www.lazydba.com/unsubscribe.html









-----------------------------------------

The information contained in this message may be privileged,
confidential, and protected from disclosure. If the reader of this
message is not the intended recipient, or any employee or agent
responsible for delivering this message to the intended recipient,
you are hereby notified that any dissemination, distribution, or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately
by replying to the message and deleting it from your computer.



Thank you. Paychex, Inc.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page