Professional Web Applications Themes

SQL2K Stored Proceedure -> .ADP 10000 Record Limitation Setting - Microsoft SQL / MS SQL Server

Hi I am trying to run a stored procedure from an access project and have come across the 10000 record default limit. I have had a google about on the subject and know that if I set "MaxRecords" from 10000 to 0 it will update my entire record set, and fix my problem, however, I cannot for the life of me find where to set the option. I am running the SP from a button on a form within the Access Data Project and have right clicked and looked in properties to find nothing. I have checked the SQL in ...

  1. #1

    Default SQL2K Stored Proceedure -> .ADP 10000 Record Limitation Setting

    Hi

    I am trying to run a stored procedure from an access project and have come
    across the 10000 record default limit. I have had a google about on the
    subject and know that if I set "MaxRecords" from 10000 to 0 it will update
    my entire record set, and fix my problem, however, I cannot for the life of
    me find where to set the option. I am running the SP from a button on a form
    within the Access Data Project and have right clicked and looked in
    properties to find nothing.

    I have checked the SQL in query yser and it does exactly what I want it
    to, for your benefit I have enclosed this within the post.

    TIA

    Bob

    UPDATE dbo.Campaign
    SET CallResultCode = NULL
    WHERE (CallResultCode = 1) OR
    (CallResultCode = 2) OR
    (CallResultCode = 3) OR
    (CallResultCode = 4) OR
    (CallResultCode = 5) OR
    (CallResultCode = 7) OR
    (CallResultCode = 17)


    Bobby Internet Guest

  2. #2

    Default Re: SQL2K Stored Proceedure -> .ADP 10000 Record Limitation Setting

    Tools
    / Options
    / Advanced
    / Client-Server settings
    Default max records

    hth,
    bob


    "Bobby Internet" <bobbyinternetNOTTHISBIThotmail.com> wrote in message
    news:#zDF2HXQDHA.1556TK2MSFTNGP10.phx.gbl...
    > Hi
    >
    > I am trying to run a stored procedure from an access project and have come
    > across the 10000 record default limit. I have had a google about on the
    > subject and know that if I set "MaxRecords" from 10000 to 0 it will update
    > my entire record set, and fix my problem, however, I cannot for the life
    of
    > me find where to set the option. I am running the SP from a button on a
    form
    > within the Access Data Project and have right clicked and looked in
    > properties to find nothing.
    >
    > I have checked the SQL in query yser and it does exactly what I want
    it
    > to, for your benefit I have enclosed this within the post.
    >
    > TIA
    >
    > Bob
    >
    > UPDATE dbo.Campaign
    > SET CallResultCode = NULL
    > WHERE (CallResultCode = 1) OR
    > (CallResultCode = 2) OR
    > (CallResultCode = 3) OR
    > (CallResultCode = 4) OR
    > (CallResultCode = 5) OR
    > (CallResultCode = 7) OR
    > (CallResultCode = 17)
    >
    >

    BobMcClellan Guest

  3. #3

    Default Re: SQL2K Stored Proceedure -> .ADP 10000 Record Limitation Setting

    Thanks Bob

    Bob


    Bobby Internet Guest

Similar Threads

  1. 10000 user
    By sjdvndjknsdn in forum Macromedia Flash Flashcom
    Replies: 2
    Last Post: November 27th, 08:47 AM
  2. FMS server record stream from stored FLV
    By B_Shack in forum Macromedia Flash Flashcom
    Replies: 2
    Last Post: September 26th, 11:24 AM
  3. Stored Procedure inserting the same record twice
    By Shmooter in forum Dreamweaver AppDev
    Replies: 5
    Last Post: June 1st, 11:26 PM
  4. Size of data stored in bytea record?
    By Carlos in forum PostgreSQL / PGSQL
    Replies: 3
    Last Post: January 26th, 04:20 PM
  5. Replies: 0
    Last Post: September 2nd, 09:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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