How To Encrypt Stored Procedure In SQL Server Hi,Guys in this tutorial i will explain you how to create a Encrypted Stored Procedure in SQL Server. Sometime we have a business logics and we want to hide the logic implementation then the schema of the stored procedure can be encrypted. Code:- CREATE PROCEDURE SP_EncryptedStoredPROC WITH […]
Category: Sql Server
SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing
How To Change Default TCP/IP Port Of SQL Server In sql server the default instance has a listener which listens on the TCP port 1433. However for the named instance the port on which the sql server listens is random and is dynamically selected when the named instance of the sql server starts. To change […]
The request failed or the service did not respond in a timely fashion. consult the event log or other applicable error logs for details. Today one of my friend called me and asked me about following error. I do a remote session of his system and have a look on event log. Their i found […]
Categories
DELETE Trigger in SQL Server
DELETE Trigger in SQL Server A DELETE trigger is a kind of stored procedure that executes itself when a DELETE statement deletes data from a table or view on which the trigger has been configured. When a DELETE trigger is fired, deleted rows from the affected table are placed in a special table i.e (deleted […]