execute stored procedure

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default execute stored procedure

    Does anybody know how I can execute one of the system stored procedures from
    master database.

    for example this is throwing error:
    <cfquery datasource="users">
    EXEC [master.dbo.sp_fulltext_catalog 'clients', 'rebuild']
    </cfquery>

    Thanks

    Buda123 Guest

  2. Similar Questions and Discussions

    1. Execute permission denied on 'stored procedure' dbo
      How to solve the problem from the above topic. I can execute the stored procedure through the web service. I am using Integrated Security connection...
    2. Problem with execute to make a stored procedure
      I have to maintain a piece of code. One of the things that is done is a create procedure: CREATE PROCEDURE PROC_22_ RETURNS(IEXTENSION...
    3. UNIX-Box slow down while execute stored procedure
      Hi, Sorry for my "special english". We are on a DGUX-Box with IDS 7.31 ( 4 P3/700 / 2 GB Mem ) We have a problem with a stored procedure...
    4. Cannot execute dynamic query in stored procedure
      Hi, I'm using ADO.NET to execute a stored proc. The stored proc contains a dynamic sql which will build the INSERT or UPDATE statement for...
    5. How can I execute a stored procedure in .net?
      Hello all, Is there anyone who can tell me how to execute a stored procedure in .net. More detailed, I want to pass some parameters to the...
  3. #2

    Default Re: execute stored procedure

    You could use CFSTOREDPROC instead of CFQUERY.....

    Your problem in this case is probably due to the way that you are attempting
    to pass your parameters. Enclose your parameters in parens.

    <cfquery datasource="users">
    EXEC master.dbo.sp_fulltext_catalog('clients', 'rebuild')
    </cfquery>

    Phil


    paross1 Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139