Skip to main content

To List down all DB Stored Procedure and Functions

 Here is a SQL Query to List down all DB Stored Procedure and Functions .We can use this to make a small tool to backup stored procedure and functions automatically using windows service .

Query:

DECLARE MY_CURSOR Cursor

FOR

SELECT TOP 1000 r.ROUTINE_NAME,r.ROUTINE_TYPE,r.Routine_Definition

FROM INFORMATION_SCHEMA.Routines r 

OPEN MY_CURSOR

    DECLARE @sproc VARCHAR(MAX) 

DECLARE @Name VARCHAR(MAX) 

  DECLARE @Type VARCHAR(MAX) 


    FETCH NEXT FROM MY_CURSOR INTO @Name, @Type, @sproc

    WHILE (@@FETCH_STATUS <> -1)

    BEGIN

        IF (@@FETCH_STATUS <> -2)

PRINT @Name

PRINT @Type

        PRINT @sproc


        FETCH NEXT FROM MY_CURSOR INTO @Name, @Type, @sproc

    END

CLOSE MY_CURSOR

DEALLOCATE MY_CURSOR

GO

Comments

Post a Comment

Popular posts from this blog

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...
Post a Comment
Read more

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
Post a Comment
Read more