Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Find Mismatched Views and Stored Procs Expand / Collapse
Author
Message
Posted Wednesday, June 4, 2008 9:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 19, 2016 7:16 PM
Points: 139, Visits: 153
Comments posted to this topic are about the item Find Mismatched Views and Stored Procs
Post #511482
Posted Tuesday, July 15, 2008 6:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 16, 2012 7:34 PM
Points: 59, Visits: 375
What version of SQL Server is the for? I'm using SQL2000 and I'm getting lots of odd syntax errors.
Post #534295
Posted Tuesday, July 15, 2008 7:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 18, 2012 7:50 AM
Points: 5, Visits: 98
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.
Post #534350
Posted Tuesday, July 15, 2008 1:17 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 21, 2016 4:28 AM
Points: 17, Visits: 141
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.
Post #534710
Posted Sunday, September 2, 2012 11:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 23, 2016 7:46 PM
Points: 1, Visits: 46
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.
Post #1353343
Posted Monday, May 9, 2016 1:22 PM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, December 8, 2016 6:45 AM
Points: 8,328, Visits: 858
Thanks for the script.
Post #1784503
Posted Monday, May 9, 2016 1:23 PM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, December 8, 2016 6:45 AM
Points: 8,328, Visits: 858
This will be really helpful.
Post #1784504
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse