Script Stored Procedures based on dependency

I don't follow the logic of a sql server farm as if they
were entirely different databases without incorporating
replication. Clustering is largely for failover I believe.
That said, this script does a nice job of creating
a sql script of all your procs from your qa/development
database in order by dependency if you really do
need to copy the procs to multiple databases:
http://www.eggheadcafe.com/articles/20030609.asp
Robbe Morris - 2004/2005 Microsoft MVP C#
Earn money answering .NET Framework
messageboard posts at EggHeadCafe.com.
http://www.eggheadcafe.com/forums/merit.asp
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:uCg%230cOpFHA.3244@.TK2MSFTNGP09.phx.gbl...
> How are people dealing with SPs in an n-tiered environment?
> If you have x number of machines and they all have to have the same SPs,
> how do you deal with changes to the SPs?
> Do you make changes to one Server and then copy them to the rest?
> We are concerned with this as we are expecting to be setting up a Web Farm
> as well as multiple Sql Servers to spread out the load.
> Thanks,
> Tom
>"Robbe Morris [C# MVP]" <info@.eggheadcafe.com> wrote in message
news:%23yphCPPpFHA.2156@.TK2MSFTNGP14.phx.gbl...
>I don't follow the logic of a sql server farm as if they
> were entirely different databases without incorporating
> replication. Clustering is largely for failover I believe.
I am not really sure, either.
This was something that was brought up at one of our development meetings
that one of our partners used (with oracle, actually I believe). They were
talking about outgrowing the server they had and needed to add servers to
spread the load. Not really sure how they were doing it.

> That said, this script does a nice job of creating
> a sql script of all your procs from your qa/development
> database in order by dependency if you really do
> need to copy the procs to multiple databases:
> http://www.eggheadcafe.com/articles/20030609.asp
Like it.
Worked like a charm, with no changes at all.
Thanks,
Tom
> --
> Robbe Morris - 2004/2005 Microsoft MVP C#
> Earn money answering .NET Framework
> messageboard posts at EggHeadCafe.com.
> http://www.eggheadcafe.com/forums/merit.asp
>
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:uCg%230cOpFHA.3244@.TK2MSFTNGP09.phx.gbl...
>