Categories
Sql Server

DDL Triggers to Audit Database-SQL Server

DDL Triggers to Audit Database-SQL Server In this post we will discuss how to audit database with DDL trigger or DDL Triggers to Audit Database-SQL Server. By this we can track all DDL events performing on a database, what was changed, when and by whom . Enable TCP/IP Protocol in SQL Server Configuration Manager Using Command Prompt […]

Categories
Sql Server

Central Management Server In SQL Server

Central Management Server In SQL Server Central Management Server In SQL Server designate an instance of SQL Server as a central management server in SQL Server. Central management servers store a list of all instances of SQL Server that is organized central management server groups. Actions will act on all servers in the server group of central […]

Categories
Sql Server

How to Drop Multiple Table with a Naming Pattern in SQL SERVER

How to Drop Multiple Table with a Naming Pattern in SQL SERVER Tomorrow I got an email from my boss to drop all tables starting with naming pattern ‘DUMMY’ in test database. There are thousand of tables with NAMING PATTERN DUMMY in that database. It is very annoying to delete all the tables one by […]

Categories
Sql Server

Import Data From Excel to SQL Server Using SSIS

Import Data From Excel to SQL Server Using SSIS In this post we will learn how to Import Data From Excel to SQL Server Using SSIS or how to import data from excel to sql server. In this SSIS package we have to configure Excel Source and OLEDB destination. After Configuration and connection setup is done you […]