Check In Encrypted Procedures to VSS

Question

I am trying to cut-over stored procedures from SSMS to Visual Source Safe. My question is this. I have a few procedures which are encrypted with the WITH ENCRYPTION keyword. Now if I am to check-in these procedures to VSS, will I still be able to check it out considering that it is encrypted?

What I know is that I cannot view the script directly through SSMS unless I decrypt the procedure. But I don't know about checking it in through VSS.

What exactly are you checking in? A source file? – SLaks Apr 30 '13 at 20:03 — SLaks, Apr 30 '13 at 20:03
Yes, I am checking in a .sql file stored procedure. – Smiley Apr 30 '13 at 20:04 — Smiley, Apr 30 '13 at 20:04
You do realise that VSS is deprecated? – David Atkinson Apr 30 '13 at 22:02 — David Atkinson, Apr 30 '13 at 22:02

score 0 · Answer 1 · answered Apr 30 '13 at 20:13

0

Putting the text WITH ENCRYPTION in a plain text file (eg, a .sql source file) does not magically make the file unreadable.

That will work fine.

answered Apr 30 '13 at 20:13

SLaks

868,454
176
1,908
1,964

Check In Encrypted Procedures to VSS

1 Answers1