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!

Views anda Store Procedure with encryption

Status
Not open for further replies.
oigo

oigo

Programmer
Apr 27, 2002
23
0
0
CO
Hello, I made a store procedure and one view with ENCRYPTION , how can I their text using T-SQL?

Thanks
 
Sort by date Sort by votes
You can't view the text of an encrypted View or Procedure. Hopefully, you've saved the unencrypted source code. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
259
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Update with a month name 1
Replies
9
Views
165
gmmastros
gmmastros
TheBugSlayer
  • Locked
  • Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks 2
Replies
10
Views
183
gmmastros
gmmastros
Cpreston
  • Locked
  • Question
Field change as caused issues to store procedure
Replies
19
Views
98
Andrzejek
Andrzejek
Billz66
  • Locked
  • Question
need to udate table entry with number containing a *
Replies
11
Views
115
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top