Various situations in which two similar but different procedures are compared, are not picked up as differences when compared in Toad's Schema Compare tool. The only differences that are picked up are differences with the parameter. Other then that, the compare shows that they are the same when they are obviously not.
Ex:
CREATE PROC [dbo].[ToadTest] ( @TestText varchar(50) = 'Toad')
/*************************************************************************************
--Procedure Name: ToadTest
--Tables accessed: None
--Other SP's Called: None
************************************************************************************/
AS
BEGIN
...
Sample attached.
Compare is having trouble when there is a hyphen-hyphenapostrophe combination in the script.
WORKAROUND:
Remove the hyphen-hyphenapostrophe combination.
STATUS:
Waiting for fix in a future version of Toad for SQL Server.
