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
iPad-Export PDF from Word This post is about iPad-Export PDF from Word.Microsoft office for iPad is a great tool. It had lots of features and solved a lot of day to day issues like editing and sending these document while traveling or outside office. The great thing is it’s FREE. You just have to sign
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.
SQL Query Result set to Html Table In this post we will discuss how to get SQL Query Result set to Html Table. Getting SQL query results to a html is very useful. It is very useful for reporting purpose. In my day to day activities as SQL Sever DBA i have to send a report