June 4, 2008 at 9:28 am
Comments posted to this topic are about the item Find Mismatched Views and Stored Procs
July 15, 2008 at 6:33 am
What version of SQL Server is the for? I'm using SQL2000 and I'm getting lots of odd syntax errors.
July 15, 2008 at 7:11 am
Provided script failed to create sp_utl_FindMisMatchedObjects in SQL Server 2005 with the following error:
Msg 4145, Level 15, State 1, Procedure sp_utl_FindMisMatchedObjects, Line 26
An expression of non-boolean type specified in a context where a condition is expected, near 'or'.
Msg 102, Level 15, State 1, Procedure sp_utl_FindMisMatchedObjects, Line 27
Incorrect syntax near ')'.
-- End of Post.
July 15, 2008 at 1:17 pm
Rich.Gamble (7/15/2008)
Provided script failed to create sp_utl_FindMisMatchedObjects in SQL Server 2005 with the following error:Msg 4145, Level 15, State 1, Procedure sp_utl_FindMisMatchedObjects, Line 26
An expression of non-boolean type specified in a context where a condition is expected, near 'or'.
Msg 102, Level 15, State 1, Procedure sp_utl_FindMisMatchedObjects, Line 27
Incorrect syntax near ')'.
-- End of Post.
Change
if(not (select * from sys.databases WHERE name =@strDBName1)
or not exists(select * from sys.databases WHERE name =@strDBName2)
to
if(not exists (select * from sys.databases WHERE name =@strDBName1)
or not exists(select * from sys.databases WHERE name =@strDBName2)
Otherwise, a handy procedure.
PS: it doesn't run in 2000, only in 2005.
September 2, 2012 at 11:54 pm
Amazingly, I was starting to write something like this - select from sysobjects into temporary tables, etc, when my e-mail went boing and this arrived - excellent script, and PERFECT TIMEING thank you very much.
May 9, 2016 at 1:22 pm
Thanks for the script.
May 9, 2016 at 1:23 pm
This will be really helpful.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply