Unanswered: Can SQL server release objects automatically?
I am running SQL Server 2000 to support the web applications. Periodly the new vervion is releases, I modified stored procedures, tables and views, or created new one on development server. Then release them to production servers. Now I generate scripts one by one from development server first, then run scripts to release them on production server.
Is this any way I can release these objects automatically? I am looking for some tools. If I imput object names, they can generate scripts or release new version to all databases on production server automatically.