Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2000
>Have multiple SQL servers that we would like to be able to update its stored procedures and functions at the same time. Wrote a VFP program to do that, it works well, but some times the stored procedures are too large and will have ODBC problems.
>
>What is the best way to update procedures and functions on multiples servers?
>We don’t want to create the wheel from scratch if there is already something out there that can help.
>Any suggestions will be greatly appreciated.
Mike,
One idea is to put all of the ALTER PROCEDURE statements into one script file, then create a DTS task that executes the script on each server.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement