Change Data Capture in SQL Server

Change Data Capture in SQL Server Change data capture in SQL Server is a feature that is introduced in SQL Server 2008. And is called CDC (Change Data Capture). CDC helps SQL Server developers to archiving and capturing data changes without any additional programming. CDC only tracks changes in user-created tables. Because captured data is

Foreign key in phpmyadmin

Foreign key in phpmyadmin Setting Foreign key in phpmyadmin is very easy. We just have to follow few simple steps and we are done. Here we are creating three tables(Product_master, Category_master and Order_master). He have to setup Foreign key in Order_master table i.e. refers to product_master and category_master table. Below i am showing you tables structure’s. After

WAMP: Forbidden You don’t have permission to access /phpmyadmin/ on this server

WAMP: Forbidden You don’t have permission to access /phpmyadmin/ on this server In this post we will discuss how to solve error: WAMP: Forbidden You don’t have permission to access /phpmyadmin/ on this server. Recently i am working on a project on which we have to install WAMP Server on windows Server and team members have

Could not load file or assembly ‘System.EnterpriseServices’ or one of its dependencies. An attempt was made to load a program with an incorrect format

Could not load file or assembly ‘System.EnterpriseServices’ or one of its dependencies. An attempt was made to load a program with an incorrect format In this post we will discuss how to solve this error: Could not load file or assembly ‘System.EnterpriseServices’ or one of its dependencies. An attempt was made to load a program with

SQL Server DBA Interview Questions and Answers for Experienced

SQL Server DBA Interview Questions and Answers for Experienced Qus: Different type of pages in SQL Server? Ans: The following table shows the page types used in the data files of a SQL Server database. Page type Decription Data It holds the data of the table for databases.The format of the page is header , data rows and

SQL Server DBA Interview Question Accenture

SQL Server DBA Interview Question Accenture In this post we will provide some SQL Server DBA Interview Question Accenture, these questions asked from one of friend recently go for interview in accenture for SQL Server DBA position. Qus: Difference between Log Shipping and Database Mirroring? Ans: Log shipping DB Mirroring Primary server, secondary server and monitor

Enable TCP/IP Protocol in SQL Server Configuration Manager Using Command Prompt

Enable TCP/IP Protocol in SQL Server Configuration Manager Using Command Prompt Hi friends, in this tutorial we will explain how to Enable TCP/IP Protocol in SQL Server Configuration Manager Using Command Prompt. Here we are not using GUI. This question is asked by one of my friend in a interview. First of all open command prompt