Shivam Dogra

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 >>

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 >>

In this article, we will discuss an error “Msg 266: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements.” that I faced when I was working with the SQL Server transactions and stored procedures. I will describe how I encountered the issue. Also, I will explain the cause and solution of … Read more >>

In this SQL Server tutorial, we will learn How to create a stored procedure in SQL Server for search functionality. We will also discuss different examples of search functionality. The complete list of topics discussed in this article is listed below. So, before creating a stored procedure to implement some search, first, we should understand … Read more >>

This tutorial is about the try-catch in SQL Server stored procedure with examples. We will discuss some of the examples that will help you understand exception handling more deeply. Also, in the end, we will discuss the best practices of exception handling in stored procedures in SQL Server. You can also learn more about exception … Read more >>

In this article, you will know about the error “Msg 11555 NOT NULL parameters are only supported with natively compiled modules, except for inline table-valued functions.” Also, we will discuss why this error arises and what things to do to resolve this error. Problem Recently, I was working with the SQL Server Stored Procedure Parameters. … Read more >>

To add SQL Server stored procedure parameters, list them after the procedure name: an @name, a data type, and = value if the parameter should be optional. Tested on SQL Server 2025 (17.0.1000.7) Standard Developer edition through sqlcmd, server collation SQL_Latin1_General_CP1_CI_AS. Below: defaults, a NULL catch-all search, OUTPUT, table-valued parameters, and the real Msg 201 … Read more >>

If you need an orders query to run from an app, a job and a teammate’s script, save it as a stored procedure. The SQL Server create stored procedure syntax is short: CREATE PROCEDURE dbo.usp_Name AS BEGIN … END;, alone in its batch. Most first tries break that batch rule or fail on the second … Read more >>