var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to check stored procedure?
I have some stored procedures that run on SQL2K(SP3) /WIN2K. Sometimes I modify them using ALTER PROCEDURE statements. How to check if they are changed after ALTER statements run? Thanks.
For a procedure named myProc, I would probably use:
EXECUTE sp_helptext myProc
You can compare the binarychecksum value of the procedure before and after your ALTER statement.
Please give some more details about what you are doing and why.
Thanks for reply. Follow Pat, the SP name is MyProc as
CREATE PROC MyProc
SELECT * FROME MyReport
I want to change @scroe data type and run:
ALTER PROC MyProc
SELECT * FROM MyReport
How to check if @score has been changed to SMALLINT? Thanks a lot.
If you execute the code snippet that I posted earlier, it will show you the source code of the stored procedure as the server "sees" it. You can just read the procedure's source code to verify that it does what you think it should.