xp_sendmail format - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

xp_sendmail format

Author

Topic

corvalion
Starting Member

6 Posts

Posted - 2004-07-09 : 10:27:48

I've created a stored procedure to export via zp_sendmail that works fine . The problem is the formatting of it, its spreadout and is very hard to read etc. any ideas ?. here is the code .

CREATE PROCEDURE [dbo].[sp_ToBeMailed] AS
SELECT call_no, line_no, part_no, reason, comments, requested_by
FROM dbo.man_adj
WHERE (adjusted = 0) AND (Mailed = 0)
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[man_adj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[man_adj]
GO

CREATE TABLE [dbo].[man_adj] (
[id] [int] NOT NULL ,
[requested_by] [nvarchar] (250) COLLATE Latin1_General_CI_AS NULL ,
[date_time] [smalldatetime] NULL ,
[adj_by] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[call_no] [nvarchar] (250) COLLATE Latin1_General_CI_AS NULL ,
[part_no] [nvarchar] (250) COLLATE Latin1_General_CI_AS NULL ,
[line_no] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[reason] [nvarchar] (250) COLLATE Latin1_General_CI_AS NULL ,
[comments] [ntext] COLLATE Latin1_General_CI_AS NULL ,
[adj] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[adjusted] [bit] NOT NULL ,
[date_adjusted] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[Mailed] [bit] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-07-09 : 13:03:54

You can't format xp_sendmail. You might consider running xp_sendmail with a query and attach the results.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources