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
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
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
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
Dedicated administrator connections are not supported via SSMS as it establishes multiple connections by design Recently i am working on a Server and i want to use DAC (Dedicated Administrator Connection) via SSMS. But i have ended up with following error: Dedicated administrator connections are not supported via SSMS as it establishes multiple connections by design.