Encrypting a stored procedure will hide the definition of the procedure from users and it definition will not be displayed in the activity monitor.
The procedures can be encrypted by using “WITH ENCRYPTION” clause after the create statement.
ex: Read more…
Alter (2)
alter (1)
alter (2)
ASCII (3)
Audit (1)
Basics (3)
Book I (1)
Book II (1)
Book III (1)
Bulk Insert Task (1)
Collations (1)
Connection Managers (2)
Copy Objects (1)
Create database (1)
DataTypes (1)
DataTypes (1)
DBCC (1)
DBCC (1)
DFT (3)
Dimensions (1)
DTC (1)
Error Messages (13)
Errors (1)
Execute SQL Task (1)
For Loop Container (1)
Functions (5)
Functions and DMVs (36)
Insert (7)
Interview Questions (3)
Joins (11)
Logging (2)
Operators (3)
Operators (2)
Procedures (1)
Procedures (2)
Query (3)
Query Hints (1)
Restore Database (2)
Schedule task (1)
Script task (1)
Sequence Container (1)
SQL Queries (8)
SQL Queries (62)
SQL Server (90)
SQL Server (8)
Sql Server 2008 (3)
SQL Server 2012 (2)
SSAS (1)
SSAS (3)
SSAS (2)
SSIS (19)
SSIS (1)
SSIS (2)
SSIS 2008 (11)
SSIS Basics (3)
SSIS Errors (1)
SSIS Tasks (11)
Storage Space (6)
Stored Procedures (18)
String Functions (4)
System Stored Procs (9)
T-SQL (9)
T-SQL (19)
T-SQL (64)
Task Scheduler (1)
Tips & Tricks (19)
Unknowns (1)
Videos (1)
Videos (3)
Videos (3)
Writeback (1)
WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Feb | ||||||
| 1 | 2 | 3 | 4 | 5 | 6 | |
| 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 21 | 22 | 23 | 24 | 25 | 26 | 27 |
| 28 | 29 | 30 | 31 | |||