Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2014
    Posts
    9

    Unanswered: Same SQL, Same permissions, different results HELP!?

    Afternoon All,

    Apologies in advance as I am unable to post the script, however, I am running the exact same script as 4 other computers on the company network (two admins and one who has the exact same permissions as me), they are all getting the correct results and I am getting completely different figures. Any ideas at all would help as we don't have a clue?

    I thought it was permissions but that has now been ruled out.

    Maybe system settings?

    The script contains:

    SELECT
    USE
    CREATE
    UPDATE
    INSERT
    BEGIN
    and some group by.

    I don't believe it's the code as we are all using the same one.

    Thank you in advance!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    pointing to the same data?
    if it was a permissions issue I'd expect the server to choke and tell you it failed.

    when you say script do you mean a script or do you mean a query or stored procedure
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2014
    Posts
    9
    Hi,

    Yes, I am in the same DB and referencing the same tables/columns etc. By script I just mean the SQL code in general.

    We have tried putting the correct version on the admin PC into a stored procedure and running that from my machine... This also does not bring back the same information.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Why don't you share your script with us.
    Are you using any non-deterministic functions?
    George
    Home | Blog

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Do any of the views have anything like
    Code:
    where username in (some list)

  6. #6
    Join Date
    Jun 2014
    Posts
    9
    Quote Originally Posted by MCrowley View Post
    Do any of the views have anything like
    Code:
    where username in (some list)
    Hi MCrowley,

    No username searches either.

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Ooh this fun......
    20 questions with the aim of divining what is occuring with deliberately obtuse answers prividing the minimum of information


    .... on second thoughts Ive got some paint that needs watching, it wont dry by itself y'know
    I'd rather be riding on the Tiger 800 or the Norton

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'm pretty sure that something simple is broken.

    You need to hire someone that you trust to access both the server and your workstation. It shouldn't take too long (probaby an hour or two), but without access to what is happening (the SQL code, the server, and possibly the workstation), the chances of solving this are very slim.

    0PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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