Archive for the ‘SQL Server’ Category

Enable SSL encryption for SQL Server instance

In this article we will try to use certificate to encrypt client connection for sql server via secure socket layer (SSL). If we are doing this on domain joined machine we need below configuration: 1. One domain controller machine (dc.sqllab.local). Install Certificate authority with Web enrollment and online responder. 2. Second domain joined machine. (be.sqllab.local). […]

How to delete/drop all the tables from SQL Server

If we want to delete or drop all the tables from SQL Server Database. 1) This is a hidden Stored procedure in sql server, this will be executed for each table in the database you connected. This cant be roll back. EXEC sp_MSforeachtable @command_delete = “DROP TABLE ?” 2)If u want to delete it from […]

Powered by k2schools