Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Viewing Encrypted procedure

Author  Topic 

venkath
Posting Yak Master

202 Posts

Posted - 2008-10-01 : 09:54:53
Hi All

When I try to view the existing procedure, I get the following

/****** Encrypted object is not transferable, and script can not be generated. ******/

How can I view the encrypted procedure ?

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-01 : 10:01:29
Find the source code.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2008-10-01 : 21:04:17
Have you checked in SYSCOMMENTS system table
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-01 : 21:06:19
quote:
Originally posted by saurabhsrivastava

Have you checked in SYSCOMMENTS system table



It's encrypted and therefore isn't viewable by just looking at syscomments. We won't help with decrypting it, so I'm locking this thread.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -