Search a string in all stored procedure

SELECT ROUTINE_NAME, ROUTINE_DEFINITION

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_DEFINITION LIKE '%EXEC(@%' OR ROUTINE_DEFINITION LIKE '%EXEC (@%' OR ROUTINE_DEFINITION LIKE '%EXEC @%' OR ROUTINE_DEFINITION LIKE '%sp_executesql%'

OR ROUTINE_DEFINITION LIKE '%EXEC @%' OR ROUTINE_DEFINITION LIKE '%PRINT @%'

AND ROUTINE_TYPE='PROCEDURE'

Comments

Cannot access a disposed object. A common cause of this error is disposing a context that was

Cannot access a disposed object. A common cause of this error is disposing a context that was resolved from dependency injection and then later trying to use the same context instance elsewhere in your application. This may occur if you are calling Dispose() on the context, or wrapping the context in a using statement. If you are using dependency injection, you should let the dependency injection container take care of disposing context instances. Object name: 'PropertyContext'. public class CustomerHub : Hub { public readonly ICustomerService _customerService; private readonly IServiceScopeFactory _serviceScopeFactory; public CustomerHub(ICustomerService service, IServiceScopeFactory serviceScopeFactory) { _customerService = service; _serviceScopeFactory = serviceSco...

No migrations configuration type was found in the assembly

EntiryFramework : Problem :No migrations configuration type was found in the assembly 'YourWebApplicationName'. (In Visual Studio you can use the Enable-Migrations command from Package Manager Console to add a migrations configuration). PM> enable-migrations -contexttypename ApplicationDbContext

Limit Upload File Type Extensions ASP.NET MVC 5

//----------------------------------------------------------------------- // <copyright file="AllowExtensionsAttribute.cs" company="None"> // Copyright (c) Allow to distribute this code and utilize this code for personal or commercial purpose. // </copyright> // <author>Asma Khalid</author> //----------------------------------------------------------------------- namespace ImgExtLimit.Helper_Code.Common { using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations; using System.Linq; ...

Virtual 01 Notepad

Search This Blog