Following stored procedure can be used to search any string in the definition of any stored procedure in all the user databases in a given SQL server...
Read MoreFollowing stored procedure can be used to search any string in the definition of any stored procedure in all the user databases in a given SQL server...
Read MoreSometimes SQL developers want to put some logic into their T-Sql code to check whether SQL Server running is in single-user mode . The SERVERPROPERTY() built in metadata system function can be used to identify the single-user mode. SERVERPROPERTY() function ...
Read MoreSometimes you need to get to know the status of particular SQL Server Agent job on a given date. Below Stored Procedure can be used to check whether supplied SQL Agent Job has completed successfully on the given...
Read MoreSometimes SQL developers want to put some logic into their T-Sql code to check the SQL Server failover cluster configuration mode . The SERVERPROPERTY() built in metadata system function can be used to identify the failover cluster configuration. SERVERPROPERTY() function with...
Read MoreSometimes SQL developers want to put logic into their T-Sql code to check the SQL Server authentication mode. The SERVERPROPERTY() built in metadata system function can be used to identify the SQL Server authentication mode. SERVERPROPERTY() function with IsIntegratedSecurityOnly Property will return...
Read MoreWhen you performing a huge DELETE operation with or without where clauses, transaction log might take over SQL server hard disk and it might takes long time to complete. But delete in chunks: 50,000 or 100,000 rows at a time...
Read MoreBelow user-defined scalar function help you to wrap a string in double quotes for a formatted text output...
Read MoreBelow user-defined scalar function help you to wrap a string in single quotes for a dynamic TSQL...
Read MoreError handling in T-SQL can be complex. TRY…CATCH certainly is the best way to handle errors in...
Read More