Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Proc encryption

Status
Not open for further replies.
bombdropVB

bombdropVB

Programmer
Dec 3, 2002
59
0
0
GB
Hi is there away to encryption all my stored procs in one operation, in other words a bulk encryption of all stored procs.

Thanks
 
Sort by date Sort by votes
No. You will need to run the ALTER PROCEDURE on all the procedures with the WITH ENCRYPTION option set.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

[noevil]
(My very old site)
 
Upvote 0 Downvote
Thanks was wanting to hear that though.
Looks like I'v a lot of editing to do!!!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BTrees
  • Locked
  • Question
Implement Encryption in Data Warehousing (ETL)
Replies
0
Views
26
BTrees
BTrees
MacroAlan
  • Locked
  • Question
Insert results of huge query into my table with Stored Proc
Replies
1
Views
42
Olaf Doschke
Olaf Doschke
BeatriceC
  • Locked
  • Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
44
pjw001
pjw001
ghiehotamares
  • Locked
  • Question
How to call stored procedure to display records in fron-end data entry
Replies
1
Views
44
fredericofonseca
fredericofonseca
Cpreston
  • Locked
  • Question
Field change as caused issues to store procedure
Replies
19
Views
99
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top