Se poate! Urmatoarele doua linkuri va arata exact cum:
How to send e-mail without using SQL Mail in SQL Server
Sending SMTP Mail using a Stored Procedure
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro