|
|
|
SSC Journeyman
 
Group: General Forum Members
Last Login: Monday, February 22, 2010 4:34 AM
Points: 94,
Visits: 113
|
|
|
|
|
|
Valued Member
Group: General Forum Members
Last Login: Thursday, March 18, 2010 3:06 PM
Points: 56,
Visits: 359
|
|
| What version of SQL Server is the for? I'm using SQL2000 and I'm getting lots of odd syntax errors.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, February 02, 2010 7:44 AM
Points: 4,
Visits: 70
|
|
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.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Friday, January 22, 2010 3:06 AM
Points: 8,
Visits: 36
|
|
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.
|
|
|
|
