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 Rhinorhino 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
Joined
Dec 3, 2002
Messages
59
Location
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 Question
Implement Encryption in Data Warehousing (ETL)
Replies
0
Views
210
BTrees
BTrees
MacroAlan
  • Locked
  • Question Question
Insert results of huge query into my table with Stored Proc
Replies
1
Views
306
Olaf Doschke
Olaf Doschke
BeatriceC
  • Locked
  • Question Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
380
pjw001
pjw001
ghiehotamares
  • Locked
  • Question Question
How to call stored procedure to display records in fron-end data entry
Replies
1
Views
351
fredericofonseca
fredericofonseca
Cpreston
  • Locked
  • Question Question
Field change as caused issues to store procedure
Replies
19
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top