Q1 Can anyone suggest a way to send attachments through sql server with out using Xp_sendmail ?
A1 Depending on available resources, (time, coding skill, etc.) one may create and implement a variety of Sql Server callable resources to do such kinds of things (as well as many other more unusual tasks). For example: create user xp s with whatever features are required; use sp_OACreate to instantiate OLE COM object(s) with the desired features; etc., etc., etc.,. A simpler option may be to use XP_CmdShell (with any mail client supporting the desired features with command line operations).