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

FTP(File Transfer Protocol ) configuration and testing in Windows Server 2008 R2

First of all you have to know what the FTP is " File Transfer Protocol ( FTP ) is a standard network protocol used to transfer files from one host or to another host over a TCP -based network". FTP Installation & Configuration: Step 1: Install the Web Server role with the IIS Management Console and FTP Server role services: Step 2: Add a new FTP Site Step 3: Setup the site with the default bindings and choose Allow SSL to avoid deploying a certificate: Step 4: Configure user permissions and basic or anonymous permission. If your server is connected to your domain you can specify domain users, otherwise they must be local user accounts: Note: Finally you’ll have to configure your server’s firewall rules to allow access.Disregard any existing FTP firewall rules; although they should be enabled, they don’t actually allow access! Run Allow a Program Through Windows Firewall and grant access to C:\Windows\System32\svchost.exe T...

update your package-lock.json according to what you have specified in the package.json file

The objective of the npm update command is to update your package-lock.json according to what you have specified in the package.json file. This is the normal behavior. If you want to update your package.json file, you can use npm-check-updates : npm install -g npm-check-updates . You can then use these commands: ncu Checks for updates from the package.json file ncu -u Update the package.json file npm update --save Update your package-lock.json file from the package.json file

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

Virtual 01 Notepad

Search This Blog