[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

store procedure coding to hide

Hi
I would like to ask some question on sql.
Is there a way that when we make a sql database with store procedure, can we hide the stored procedure coding from the client.
We don't want to show the client the store procedure coding that we have done.

Can any one help us...

0
abdallah1973
Asked:
abdallah1973
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
add the WITH ENCRYPTION in the create procedure statement, then the procedure code will be encrypted and cannot be seen.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Another option only for SQL 2005 is to write .NeT stored procs and functions
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now