Hello All:
This is my situation-I have a lone important stored procedure on my production server that needs to be modified. It has a lock symbol next to it, and assuming the 1 SQL_CLR userid sitting in the security group belongs to this stored procedure. This userid is referenced by "KeyName" which I also deduce this userid(which can't have it's password changed) is the keypair for this stored procedure.
I have copied the DB onto my development server just so I can decrypt this SP. I don't have the original source code(.NET SQL CLR) for this SP & when running a decrypt stored procedure I found on the internet...I get this error:
Cannot perform alter on 'problemSP' because it is an incompatible object type.
environment
Production server:x64-SQL05
Development Server: x32-SQL08
VS-2008
My Questions: Is there anyway to decrypt/unlock this stored procedure?...If not is there any way I can just "view" the SP to possibly get the code(trace or something else)?
Is there a way to access the code(SP) thru VS.NET(with/without a keycode)?