How to search for text in a SQL Server stored procedure, function, or view?
You can use the following T-SQL query to search for text in a SQL Server stored procedure, function, or view.
Recent posts
The action cannot be completed because the file is open in w3wp.exe
Are you unable to delete the files because w3wp.exe prevents you from deleting the files from the Windows server?
How to replace the last or first character of the string in excel?
There are various use cases to remove the tail end character, like replacing the alias name, ex: 16 seconds or 16s to 16. It can be trimmed using the excel i...
How do I detect a browser or tab closing using router deactivate in Angular?
There is no built-in way to detect when the browser or tab is closed in Angular, but you can use the window object’s ‘beforeunload’ event to trigger an event...
How do I detect a browser or tab closing using hostlistener in Angular?
There is no built-in way to detect when the browser or tab is closed in Angular, but you can use the window object’s ‘beforeunload’ event to trigger an event...
How to enable or disable the windows and anonymous authentication in Microsoft Visual Studio 2019?
To enable or disable Windows and anonymous authentication in Visual Studio 2019, you need to modify the properties from the project property window or from t...
How to merge two arrays in angular and typescript?
We will see how to merge one or more arrays using TypeScript. The concat() method returns a new array by concatenating two or more arrays, while the spread o...
How to find locked tables and kill the session in Microsoft SQLServer?
Open SQL Server Management Studio (SSMS). Connect to the SQL Server instance. Open a new query window. Execute the following query to find the sessi...
How to update the Jira issue description field using the custom listener and grovvy script?
Are you looking to update the Jira issue description field in an automated manner? If yes, the below script will help you update the description field. If th...
How to use a JIRA custom listener to copy comments from the parent issue to subtasks and vice versa?
You can copy the comment added in the parent issue to all the associated sub tasks and also copy the comment entered in the subtask to the parent issue using...
How to use a JIRA custom listener to copy comments from the parent issue to all sub tasks?
You can copy the comment added in the parent issue to all the associated sub tasks using the JIRA custom listener and grovvy script. All you need to do is to...
How do I use a JIRA custom listener to copy comments from the subtask to the parent issue?
You can copy the comment added in the sub task to it’s parent issue using the JIRA custom listener and grovvy script. All you need to do is to setup the cust...
How to assign the subtask to the reporter after it is closed?
Usecase: The jira admin creates a subtask in the parent issue and assigns it to the ‘developer 1’. The subtask needs to be automatically assigned back to the...
How to prevent closing the parent issue before closing all sub tasks in Jira script runner using Groovy script?
The developers sometimes forget to close their sub tasks, and someone closes the parent issue without checking the sub task status. You can prevent closing t...
Making custom fields is required in a workflow transition in Jira (ScriptRunner)
This post describes what to make a custom field requires during a work flow transition. If you are using Script Runner for Jira, you can use the Field(s) req...
JIRA - How to set custom field value in script runner using groovy script?
Jira allows you to create a custom field and the value can be set during the transition, so when you view or edit the issue, then the custom value will be di...
How to get the value of textarea in jQuery?
You can get the value of the <textarea> control in jQuery using the below code snippet.
How to add or remove multiple classes in jQuery?
You can add or remove multiple classes from div/span/any tag in jQuery using the below code snippet,
How to add or remove the class of the div using jQuery?
You can add or remove the class of the div in jQuery using the below code snippet,
HTTP Error 500.19 - Internal Server Error
Error: HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid.