SQL Server Stored Procedure Encryption
-
Hi there, I am trying to encrypt my sotred procedures with "WITH ENCRYPTION" clause like this
ALTER PROC myProcedure WITH ENCRYPTION. It works well for the stored procedure that has not parameters but for a stored procedure with parameter list it generates the following error."Incorrect syntax near '@p_param1'."where @p_param1 is the first parameter. Note that this SP is giving the proper results and runs well. Thanx in advanceMujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
-
Hi there, I am trying to encrypt my sotred procedures with "WITH ENCRYPTION" clause like this
ALTER PROC myProcedure WITH ENCRYPTION. It works well for the stored procedure that has not parameters but for a stored procedure with parameter list it generates the following error."Incorrect syntax near '@p_param1'."where @p_param1 is the first parameter. Note that this SP is giving the proper results and runs well. Thanx in advanceMujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
Try adding the WITH clause after your parameters list like
create procedure testproc @param1 int with encryption as begin [your stmts here] endSG Cause is effect concealed. Effect is cause revealed.
-
Try adding the WITH clause after your parameters list like
create procedure testproc @param1 int with encryption as begin [your stmts here] endSG Cause is effect concealed. Effect is cause revealed.
Well I wonder why this idea didn't struck me. :) that was too simple. Thanx for help SimulationofSai.
Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."