Professional Web Applications Themes

Strange things with query execution - Microsoft SQL / MS SQL Server

Hi there!!! In my application I'm forming file which stores SQL statements. Then some part of this statements are retrieved from file and executed, the file is truncated. This process continues until the file is empty. Then when yzing data on the server, I notices that all the statements are executed, but part of the "delete from... " are not executed, however server doesn't throw any exceptions. On the other hand, I've tried to execute the statements manualy via Queryyzer - everything is ok. What this can mean? Any help will be appreciated......

  1. #1

    Default Strange things with query execution

    Hi there!!!

    In my application I'm forming file which stores SQL
    statements. Then some part of this statements are
    retrieved from file and executed, the file is truncated.
    This process continues until the file is empty.

    Then when yzing data on the server, I notices that all
    the statements are executed, but part of the "delete
    from... " are not executed, however server doesn't throw
    any exceptions.

    On the other hand, I've tried to execute the statements
    manualy via Queryyzer - everything is ok.

    What this can mean? Any help will be appreciated...


    Vadym Guest

  2. #2

    Default Re: Strange things with query execution

    Permissions of the user account the process is running under? I gues this is
    the SQL Server Agent's account?

    --
    Dejan Sarka, SQL Server MVP
    FAQ from Neil & others at: http://www.sqlserverfaq.com
    Please reply only to the newsgroups.
    PASS - the definitive, global community
    for SQL Server professionals - http://www.sqlpass.org

    "Vadym Stetsyak" <net> wrote in message
    news:000a01c35c2c$f5264bf0$gbl... 


    Dejan Guest

  3. #3

    Default Re: Strange things with query execution

    With user permission everything is ok.
    The problem was solved.

    "Dejan Sarka" <si> wrote in
    message news:phx.gbl... 
    is 
    >
    >[/ref]


    Vadym Guest

Similar Threads

  1. strange things happening..
    By iambrew in forum Macromedia Contribute General Discussion
    Replies: 3
    Last Post: December 28th, 07:20 PM
  2. Strange Things
    By myIP in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: April 29th, 05:32 AM
  3. Strange things in Opera...
    By Steve in forum Macromedia Flash Sitedesign
    Replies: 4
    Last Post: January 7th, 07:44 AM
  4. seeing strange things?
    By Micah Montoy in forum PHP Development
    Replies: 2
    Last Post: July 9th, 10:54 AM
  5. [PHP] seeing strange things?
    By Mike Ford in forum PHP Development
    Replies: 0
    Last Post: July 9th, 10:12 AM

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