External Article

Options for hiding SQL Server code

  • Article

I am aware of the WITH ENCRYPTION clause that is used to encrypt the code for objects like views, stored procedures and functions. It sort of fulfills my purpose and is easy to implement, but it does not cover all SQL Server objects. In this tip we look at another option to restrict users from viewing the definition/code of any SQL Server object.


5,538 reads


Daily Coping 2 Feb 2023


Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023


Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Why Managed Identities are Awesome


For the first workdays of this new year, I had the pleasurable task of...

Read the latest Blogs


The Senior Advantage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Senior Advantage

Can you help me understand what this stored procedure call returns?

By SQL_Surfer

Definition of stored procedure   create procedure [dbo].[smGetMinDate] @O_dMinDate datetime = NULL output as...

Restrict available values from one parameter per othr parameters selected values

By catbeasy

Hello Have created a simple 9 column report where there are 7 (multi valued)...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers