Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 87
  • Last Modified:

How to save an execute as a stored procedure so I can just run it

Hi:

I have a stored procedure that takes a number of parameters.  Rather than select the parameters each time, I'd just like to run it  - e.g. RunDefrag.

I tried to save as a stored procedure but go a grammar error.  

CREATE PROCEDURE [RunDefrag]
        EXECUTE dbo.dba_indexDefrag_sp
              @executeSQL           = 1
            , @printCommands        = 1
            , @debugMode            = 1
            , @printFragmentation   = 1
            , @forceRescan          = 1
            , @maxDopRestriction    = 1
            , @minPageCount         = 8
            , @maxPageCount         = NULL
            , @minFragmentation     = 1
            , @rebuildThreshold     = 30
            , @defragDelay          = '00:00:05'
            , @defragOrderColumn    = 'page_count'
            , @defragSortOrder      = 'DESC'
            , @excludeMaxPartition  = 1
            , @timeLimit            = NULL
            , @database             = 'testDB';

Any help in figuring how to do this would be greatly appreciated.

RBS
0
RBS
Asked:
RBS
1 Solution
 
ste5anSenior DeveloperCommented:
hmm, just correct it:

CREATE PROCEDURE [RunDefrag] 
AS
 // your sprocs body.

Open in new window

0
 
RBSAuthor Commented:
Duh - thanks (blush)

RBS
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now