If anyone is interested. I had come across some stored procs and triggers that had been encrypted in a database. I had to decrypt these so I could make changes.
The one of our ex-coders had encrypted them for some job security reason I guess. Who knows. But I found a SQL script file that creates a stored proc to use for decrypting the encrypted triggers and store procs. You can get the SQL script file from here: http://www.mssqlcity.com/FAQ/Devel/DecryptSP.htm Shawn Regan ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists