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.




MS Sql Server LazyDBA home page