>We have made some major changes to our tables. Is there a way to programmatically syntax check all stored procedures all at once?
Hi Mike,
Just an untested idea. You can get the list of all stored procedurec and there text using following select. Keep in mind that there could be more than one line per stored procedures because there text is stored in chunks.
SELECT so.name, so.id, sc.colid, sc.text
FROM sysobjects so
JOIN syscomments sc ON sc.id = so.id
WHERE type = 'P'
After that you can send each stored procedure for parsing using SET PARSEONLY ON statement.
--sb--