Results 1 to 3 of 3

Thread: @query error???

  1. #1
    Join Date
    Feb 2004
    Location
    Australia
    Posts
    183

    Angry Unanswered: @query error???

    ODBC error 4604 (42000) There is no such user or group 'sa8'

    this is the error message I get when I run my stored procedure that has the @query parameter and I have been told this is a bug within sql that microsoft doesn't seem to be aware off.

    Are you coming across this and what do you do to go around it???

    Regards

  2. #2
    Join Date
    Oct 2003
    Location
    Buenos Aires, Argentina
    Posts
    20
    Hi:

    I have found this "solution". Please check if you can use it

    We had a similar problem, the way we got around it was to add access rights to the TEMP directory in the Document and Settings folder on the account logged into the Server. As we had the NT Administrator account permanatley logged onto the server. If I tried to run a temp query from xp_sendmail it would fail, but if I used the administraor account it worked okay. The query writes the output file it needs to to the temp folder of which we had no access rights. Once I changed the access rights it worked okay. Did find this answer in one of the many SQL forums on the net. Hope this help you.
    ------------------------------------
    Thanx
    ------------------------------------
    http://www.iespana.es/greatavatar/FIRMA/firma.jpg

  3. #3
    Join Date
    Oct 2003
    Location
    Buenos Aires, Argentina
    Posts
    20
    I hope I can be more helper
    ------------------------------------
    Thanx
    ------------------------------------
    http://www.iespana.es/greatavatar/FIRMA/firma.jpg

Posting Permissions

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