Send extract to different server or email attachment

• poratips

  Hall of Fame

  Points: 3994

  More actions

  December 2, 2008 at 6:41 pm

  #216031

  Hi,

  I am new for sql server and i have to run few queries and extract results in csv format and send it to either different server or as a email attachment and need to schedule the job for automation.

  I am running sql server 2005.

  Please let me know if you need more information.

  My query might joining two or more than two tables.

  Thanks,

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  December 2, 2008 at 7:33 pm

  #906610

  Yes, we need more information. Please read the following article and then provide the information that it describes in the format that it shows: http://www.sqlservercentral.com/articles/Best+Practices/61537/

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]