Verify SQL Server Stored Procedures are the same on multiple servers

Posted on SQL Server Central See other posts from SQL Server Central
Published on Mon, 09 Apr 2012 06:00:00 UT Indexed on 2012/04/10 11:37 UTC
Read the original article Hit count: 160

Filed under:

I have a stored procedure I push down to all of my servers that does a custom backup job and I want to make sure all servers have the same stored procedure. Is there some way to check without going to each server and reviewing the stored procedure? Check out this to find out.

SQL Monitor New! SQL Monitor 3.0
Red Gate's multi-server performance monitoring
and alerting tool gets results from Day One.
Simple to install and easy to use –
download a free trial today.

© SQL Server Central or respective owner