TSQL-Checking Database Recovery Model In this post we will learn how to check recovery model of all database hosted on your SQL Server or you can say TSQL-Checking Database Recovery Model. This is very easy we just have to run a script to do this. Earlier we had discussed about Change Data Capture in SQL Server, DDL Triggers
How To Know Uptime Of SQL Server By TSQL Hi friends, in this post we will discuss how to know uptime of SQL Server by TSQL or you can say how to check sql server uptime through tsql. Earlier we had discussed about SQL Server Schema Ownership, How to create a database in sql server with Tsql, Enable
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.