Re: Is there a tool/util/script to do syntax check of all stored procedures?
From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 12/04/04
- Next message: John A Grandy: "COALESCE(DateCreated,GETDATE())"
- Previous message: Dan Guzman: "Re: Read/Export Binary Data"
- 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
- Next message: John A Grandy: "COALESCE(DateCreated,GETDATE())"
- Previous message: Dan Guzman: "Re: Read/Export Binary Data"
- 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 ]
Relevant Pages
|
