Results 1 to 12 of 12
  1. #1
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Angry Unanswered: sexstatevariable =3 error (was "SQLServer-2000")

    Quite often a scheduled program run causes the following error and program fails. If I run it a couple of times then it goes away for some days but re-appears again sporadically. Any thoughts what to look for and how to fix this? Help is appreciated.

    sexstatevariable =3

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Do you really think this is enough information for anyone to help troubleshoot your problem? Did you read the sticky at the top of the forum?

    Help us to help you!

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Reply

    Unfortunately I have only that much information. Since the originator is a program executable I can not write that here and I do not have any information more than that is popping up. I thought someone has seen that "sexstate variable =3" in MSSQL either in hardware issue or other software issues and just wanted to get a direction where to look at.

  4. #4
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Have you tried knowledgebase or google or actively searching the web?

    -- This is all just a Figment of my Imagination --

  5. #5
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Tried those

    but did not get any results.

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by vkaramched
    Unfortunately I have only that much information. Since the originator is a program executable I can not write that here and I do not have any information more than that is popping up. I thought someone has seen that "sexstate variable =3" in MSSQL either in hardware issue or other software issues and just wanted to get a direction where to look at.
    The program that gives the message is an exe? Do you have the source code or the coder of this? Is that all (and exactly) what it says ("sexstate variable =3")?

    sexstate sounds like nothing to do with SQL Server. Google doesn't recognise it (apart from a few sites more to do with sex than sql). I would put my money on this being some debugging code that made it through to the final exe and that it has nowt to do with MSSQL.

    I could be a million miles off but to be honest vkaramched you must know more than you are telling us so it is all speculation.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Honestly not

    but I wish I did know more than what I said here. The coder is gone and source code unavailable except "exe" and unfortunately program is being used. I am not a developer though, but I expected such reply here but a bleak thought was that I may get some clues also if someone has seen such a thing. However thanks for seconding my thoughts.

  8. #8
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I think sometimes non-developers feel a bit intimidated and don't give comprehensive details when posting a thread because they don't want to say the wrong thing or look foolish. Also - I imagine non-developers don't appreciate the technical trouble shooting process. It isn't magic - it is just getting a logical frame of reference and eliminating things as quickly as possible. Quite simply - we have only the information you provide to work on - and the more the better.

    The fact that it is an exe (and not SQL Server directly) that is displaying this message, the developer has gone, whether or not you have access to the source code, that you are not a devloper yourself etc are all totally relevent.

    Anyway - if you can't get hold of
    a) the developer
    b) the source code (s)he wrote (and if not why not?)
    I think you are pretty well stuck.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Damn...SQL Server has a sex variable!...go figure
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  10. #10
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by Brett Kaiser
    Damn...SQL Server has a sex variable!...go figure
    Even more interesting is that it can have a value of 3....
    Testimonial:
    pootle flump
    ur codings are working excelent.

  11. #11
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by pootle flump
    Even more interesting is that it can have a value of 3....

    I always wanted to try that setting
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  12. #12
    Join Date
    Nov 2005
    Posts
    16
    Quote Originally Posted by pootle flump
    It isn't magic
    ...but 3 is the magic number.

Posting Permissions

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