Re: Is there a tool/util/script to do syntax check of all stored procedures?

• Previous message: David Gugick: "Re: Is there a tool/util/script to do syntax check of all stored procedures?"
• In reply to: Bret Pehrson: "Re: Is there a tool/util/script to do syntax check of all stored procedures?"
• Next in thread: mark baekdal: "RE: Is there a tool/util/script to do syntax check of all stored proce"
• Messages sorted by: [ date ] [ thread ]

Date: Fri, 3 Dec 2004 20:38:24 -0600

Here's a link to a thread on this subject: http://tinyurl.com/6g27f.

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Bret Pehrson" <bret@classicade.com> wrote in message 
news:41B0EA19.E69480B3@classicade.com...
> Kalen Delaney wrote:
>>
>> Hi Bret
>>
>> Can you be a little more specific about what you want to do? Stored
>> procedures cannot be created if there are syntax errors, so they wouldn't 
>> be
>> IN the database if there were any errors.
>>
>> How are you thinking that errors might just show up at some point?
>
> What is happening is that I create a sp that is correct and working, then
> subsequently go in, for example, and change a field name in a table.  If 
> the sp
> references that field, it suddenly becomes invalidated, but that only 
> becomes
> obvious when trying to execute the sp or if I manually check the syntax.
>
> So, what I'm after is some way to do a check-syntax/recompile of all 
> stored
> procedures, and then be notified of any syntax errors.
>
> Any thoughts?
>
>
>> "Bret Pehrson" <bret@classicade.com> wrote in message
>> news:41B0DD0D.ABCB308E@classicade.com...
>> > Is there a tool/utility/script that will do a syntax check of all 
>> > stored
>> > procedures in a database?
>> >
>> > After doing some table maintenance, I occasionally have the need to 
>> > verify
>> > the
>> > associated stored procedures, and have resorted to the (very manual)
>> > process of
>> > opening a stored procedure and pressing the "check syntax" button for
>> > each...
>> > With several hundred stored procedures, it can quickly get a little
>> > tedious.
>> >
>> > Thanks 

• Previous message: David Gugick: "Re: Is there a tool/util/script to do syntax check of all stored procedures?"
• In reply to: Bret Pehrson: "Re: Is there a tool/util/script to do syntax check of all stored procedures?"
• Next in thread: mark baekdal: "RE: Is there a tool/util/script to do syntax check of all stored proce"
• Messages sorted by: [ date ] [ thread ]