Problem with scripting in SQL 2005 after SP2

Hello everyone,
We hit a snag after installing SP2 for SQL Server 2005 Standard. Basically,
when we want to script the database the server takes ages to determine
objects in the database and then it takes another age to actually script the
objects.
Before the SP2 scripting was lightning fast. Now we dread any change that
would require scripting.
Any help and/or insight much appreciated.
BR,
GAZ> Before the SP2 scripting was lightning fast. Now we dread any change that
> would require scripting.
I find Red-Gate's SQL Compare to be very fast at generating change scripts.
Yes, it is not free, but it beats Management Studio's output hands down.
Anyway, here's something from Erland that I posted in the .Tools newsgroup
just yesterday:
I haven't tested scripting with SP2 as far as I can recall, but a tip
is that setting the database in forced parameterisation, can speed up
scripting considerably, since MgmtStudio uses inlined parameter values.
See also
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=247968
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006|||Thanks for the tip. Changing the property Parametarisation to Forced has
resolved the issue. Scripting is a pleasurable task once again.
Thanks.
GAZ
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:O$UD4VcgHHA.284@.TK2MSFTNGP05.phx.gbl...
>> Before the SP2 scripting was lightning fast. Now we dread any change that
>> would require scripting.
> I find Red-Gate's SQL Compare to be very fast at generating change
> scripts. Yes, it is not free, but it beats Management Studio's output
> hands down.
> Anyway, here's something from Erland that I posted in the .Tools newsgroup
> just yesterday:
> I haven't tested scripting with SP2 as far as I can recall, but a tip
> is that setting the database in forced parameterisation, can speed up
> scripting considerably, since MgmtStudio uses inlined parameter values.
> See also
> http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=247968
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>