Microsoft SQL Server Tutorials
In this sql server tutorial, we will discuss how to fix error, the remote procedure call failed sql server configuration manager. the remote procedure call failed sql server configuration manager A few days back I got an error while using SQL Server Configuration Manager to list the services. The error states “The remote procedure call … Read more >>
In this SQL Server tutorial, we will learn about full-text search in SQL Server. Here we will learn How to enable and implement a full-text search in SQL Server. And for the implementation, we will be using SQL Server 2019. Here is the list of topics that we are going to discuss. What is full-text search in SQL … Read more >>
In this SQL Server tutorial, we will cover SQL Server check user permissions on table. In this tutorial, we will understand how we can check user permissions that are granted on a table. SQL Server check permissions on table In this section, we will understand how we can check permissions associated with a given table. For this implementation, … Read more >>
In this SQL Server tutorial, we will learn How to check if SQL Server is running or not. We will also discuss how we can check the status of different SQL Server services like an agent, browser, etc. And we will also illustrate the following topics given below. Note:- For all the demonstrations in the … Read more >>
In this SQL Server tutorial, we will learn How to get list of users, How to get a list of objects available in SQL Server. We will also demonstrate these topics with the help of examples. How to get list of users in SQL Server In this section, we will understand how to fetch all the … Read more >>
In this article, I will explain how I encountered the error “SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component ‘xp_cmdshell’.” Also, I will explain what I did to resolve this error. Problem: Recently, when I was working with SQL Server stored procedures, I wanted to create a stored procedure that creates a directory in … Read more >>
Are you new to SQL Server? Stored procedures are very important in SQL Server. In this tutorial, we will learn what is a stored procedure in SQL Server? How to create a stored procedure in SQL server 2019, Advantages of using SQL Server stored procedure. Also, we will check how to execute and alter a … Read more >>
In this sql server tutorial, we will discuss how to fix the error message “Msg 15123: The configuration option ‘xp_cmdshell’ does not exist, or it may be an advanced option.“ sql the configuration option ‘xp_cmdshell’ does not exist or it may be an advanced option Recently, when I was working with SQL Server 2019, I … Read more >>
This tutorial is about the loops in SQL Server stored procedure. You will learn how loops work in stored procedures. You will see a number of examples of loops in stored procedures in SQL Server. SQL Server stored procedure for loop SQL Server does not support FOR loop. However, you can use the WHILE loop … Read more >>
In this article, we will discuss the error message “Msg 567: Unable to retrieve data for this section of the report. Following error occurred. File is not a recognizable trace file.“ Problem I encountered this error while I was working with the Log files. I was trying to get various information about the stored procedures … Read more >>
Download A 40 pages PDF And Learn Now.