Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
darius_sutherland
Starting Member
17 Posts |
 Posted - 2009-01-26 : 10:55:53
|
| Hi.Does anybody know a good solution for the following.I have a stored procedure running on 1 client DB. There a multiple client databases and eventually I want the Procedure to be available to all databases, these databases are all the same apart from actual dataIm not keen on the whole Idea of updating 50 SP's when the code has changed..Any viable solution. Thanx in advance...State Of Mind Photography - It's This, It's That, It's The Otherwww.state-of-mind.co.uk | www.photographersinbrighton.org.uk | www.sussexweddingphotographers.org.uk |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-01-26 : 14:36:23
|
| A few things to look at. There are 3rd party tools that will let you run a sql statement on multiple sql servers/databases. I believe RedGate makes one that does this. 2008 I believe offers the ability to run a statement on multiple machines as well. There is a free add in from ssms toolpack that lets you do this as well: http://www.ssmstoolspack.com/Finally, if you have some time to learn it, I'm loving Powershell and all the things it can do that makes my life easier. Haven't tackled this particular issue yet but it can do this type of thing as well if you have the time to learn it and write it.Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
Mainting Multiple Versions Of Same SProc