Actually I want to compare two databases for Ex: TestDB to productionDB.

then we have to get all sp's from testdb and i want to create alter statement for those sp's...

Hai.

if anyone know how we can alter all storedprocedures exists in one database by using query in sqlservr 2000, please let me know.

Thanks in advance

Developer