Is it possible to use SQL Compare to compare an existing SP with a SP sent as a file by a colleague

Raynag

Hey,

As the title suggests, is it possible to compare a stored procedure on my database with a stored procedure sent to me by a colleague in a .sql file?

Cheers

sam.blackburn

You could create a scripts folder using SQL Compare and then add (or replace) the procedure inside it.  However, Compare can have some unpredictable behaviour if you cause the scripts folder to be inconsistent, for example by referencing nonexistent objects from your procedure.

Raynag

Brilliant, thank you for the quick response, much appreciated.