Categories
Sql Server

How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE

How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE In this article we will discuss How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE.The xp_cmdshell option is a server configuration option that enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system.In order to use XP_CMDSHELL you need to be a […]

Categories
Sql Server

How To Hide An Instance Of SQL Server

How To Hide An Instance Of SQL Server In this article we will learn How To Hide An Instance Of SQL Server. Sometime in your organization you has been asked for hiding an Instance of SQL Server. In earlier post we have dicussed How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE. Hiding an SQL Server Instance will help […]

Categories
Asp, Asp.net

Progress Bar Example In Asp.Net

Progress Bar Example In Asp.Net In this post we will learn how to use Progress Bar Example In Asp.Net.We are using a DropDownList with having locations of different cities, Submit button on click of Submit button the data is loaded in ASP.Net GridView. Also there’s HTML DIV which is used to display the loading progress image till […]

Categories
Sql Server

IIF() Function in SQL Server 2012

IIF() Function in SQL Server 2012 In this post we will discuss about IIF() Function.The IIF function means “Immediate IIF”.IIF is a shorthand way for writing a CASE expression.This functions take three arguments. If the first argument is true, it will return the second argument as result or it will return the third argument as […]