HighTechnologySQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing
How to Find Recently Executed Queries in SQL Server Database In this tutorial we will learn How to Find Recently Executed Queries in SQL Server Database. Below mentioned query will fetch query time and query that has been executed. For this we are using Dynamic Management Views. This is very helpful, when we have to find recently […]
How to Export Records From SQL Server to Text File using BCP In this tutorial we will learn How to Export Records From SQL Server to Text File using BCP. Bulk Copy Program (BCP) is a command-line utility that ships with Microsoft SQL Server. With BCP, you can import and export large amounts of data in and […]
The remote procedure call failed (0x800706be) In this post we will learn how to solve The remote procedure call failed (0x800706be). Today when i am try to open SQL Server Configuration manager it gives me error: The remote procedure call failed (0x800706be). Solutions: 1. Apply latest service pack. Link for SQL Server 2008 R2 Service pack1: http://www.microsoft.com/en-in/download/details.aspx?id=26727 , Link […]
How to kill All Running Processes in SQL Server In this post we will discuss How to kill All Running Processes in SQL Server. we do have solution by killing the running process to take a lock and perform any activity using a management command namely KILL & a system view sys.sysprocesses. However, what encourages me to write this solution […]