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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center