xp_sendmail

• spaski

  SSC Veteran

  Points: 230

  More actions

  August 20, 2003 at 1:34 am

  #80857

  I am trying to send qry results(say 10 records) with xp_sendmail using the following

  EXEC master.dbo.xp_sendmail 'myemail@domain.com',

  @query = 'Select TestNumber from testtable'

  then I get

  ODBC error 8198 (42000) Could not obtain information about Windows NT group/user 'WORKGR\Spaski'.

  We use Windows authentication and xp_sendmail works fine without a qry

  Is this a security problem or setup problem. I have rights on the spesific table.

  Regards

  Spaski

• fromnaija

  SSCrazy

  Points: 2876

  More actions

  August 20, 2003 at 6:46 am

  #470580

  Try using the three part naming for your table (databasename.owner.tablename).

  
  Joseph
  

• spaski

  SSC Veteran

  Points: 230

  More actions

  August 20, 2003 at 6:57 am

  #470586

  Nope stil the same error

• fromnaija

  SSCrazy

  Points: 2876

  More actions

  August 20, 2003 at 7:28 am

  #470590

  Is your domain a native Windows 2000 domain with some Windows NT server?? If yes, take a look at this:

  http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q241/6/43.asp&NoWebContent=1&NoWebContent=1

  Is your account local to the SQL Server machine or a domain account?

  When you run xp_logininfo, what do you get?

  
  Joseph
  

• spaski

  SSC Veteran

  Points: 230

  More actions

  August 20, 2003 at 7:57 am

  #470597

  This could be it. We do have a supercomputer with NT4(why I don't know), but thanks will check out the KB article.

  Regards

  Spaski