InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 21:48:14 GMT20http://www.sqlservercentral.com/Forums/Topic511482-1309-1.aspxAmazingly, 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.Sun, 02 Sep 2012 23:53:59 GMTDr Paul Davishttp://www.sqlservercentral.com/Forums/Topic511482-1309-1.aspx[quote][b]Rich.Gamble (7/15/2008)[/b][hr]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 26An 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 27Incorrect syntax near ')'.-- End of Post.[/quote]Changeif(not (select * from sys.databases WHERE name =@strDBName1) or not exists(select * from sys.databases WHERE name =@strDBName2)toif(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.Tue, 15 Jul 2008 13:17:58 GMTRoman Vinnikhttp://www.sqlservercentral.com/Forums/Topic511482-1309-1.aspxProvided 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 26An 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 27Incorrect syntax near ')'.-- End of Post.Tue, 15 Jul 2008 07:11:56 GMTRich.Gamblehttp://www.sqlservercentral.com/Forums/Topic511482-1309-1.aspxWhat version of SQL Server is the for? I'm using SQL2000 and I'm getting lots of odd syntax errors.Tue, 15 Jul 2008 06:33:12 GMTCAGreensfelderhttp://www.sqlservercentral.com/Forums/Topic511482-1309-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Development/63270/">Find Mismatched Views and Stored Procs</A>[/B]Wed, 04 Jun 2008 09:28:17 GMTPratap Prabhu