Find Mismatched Views and Stored Procs

  • Pratap Prabhu

    Say Hey Kid

    Points: 711

    Comments posted to this topic are about the item Find Mismatched Views and Stored Procs

  • CAGreensfelder

    SSC Eights!

    Points: 919

    What version of SQL Server is the for? I'm using SQL2000 and I'm getting lots of odd syntax errors.

  • Rich.Gamble

    Valued Member

    Points: 59

    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.

  • Roman Vinnik

    SSC Enthusiast

    Points: 161

    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.

  • Dr Paul Davis

    Grasshopper

    Points: 19

    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.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    This will be really helpful.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply