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

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:

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/SQLServ...dbackID=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 (AT) dnartreb (DOT) noraa> wrote