October 18, 2004 at 6:03 pm
We are looking for a tool that will go through a stored procedure and validate our rules. Rules like no lock on every select, fully qualified all objects, verify syntax. We know we could produce a tool, but was wondering if there was something similar already out there.
Let me know
Thanks
Susan
October 19, 2004 at 11:56 am
Haven't seen anything like that.
October 20, 2004 at 5:29 am
syscomments should hold the script for all procedures. Maybe consider doing query against all stored procs, and finding those that don't have certain keywords that you might require e.g. "with(nolock)".
Pretty limited, but can't see what else could work.
Chris
October 20, 2004 at 6:59 am
Actually there is something that can help you in your task. Microsoft released its sql best pratices analyser found here :
it won't do everything you asked for by it's gonna check
fully qualified object names and a LOT of other very important stuff like yukon readiness, last backup date, index fragmentation... and the list goes on for hours (and I meant it.. the first time I ran this tool it took me 3 days to correct 50% of the problems it found :-)).
As for the nolock rule I guess you'll have to code it yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply