xp_sendmail - SQL Server 7 vs. 2000

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 - SQL Server 7 vs. 2000

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-17 : 09:32:39

Kent writes "I have a bug tracking system that uses xp_sendmail to notify different departments of the logging of maintenance issues involving our software. The system has worked fine until we migrated from SQL Server 7 to SQL Server 2000. The trigger that sends mail still works but the format of the email has been mangled and we have not been able to find any documentation concerning this issue on the web or in newsgroups.

Below is an example of one of the triggers and the output for both versions of SQL Server. Any help is appreciated.

create trigger user1.Test1 on user1.TableA
for insert as
commit
declare @mysubject varchar(110), @module varchar(25), @lognum as int, @log varchar(4)
select @module =mod, @lognum=logger from user1.TableA
set @log=@lognum
set @mysubject = 'A fix has been certified "Completed" for bug #'+ @log +' for ' + @module + '.'
execute master..xp_sendmail 'kent.davis@tsa.advet.com',
@subject = @mysubject,
@query='select logger as "LabelA" from user1.TableA;
select column1 as "columnA" from user1.TableB,user1t.TableA where
user1.TableB.log_num = user1.TableA.logger;
select column2 as "columnB" from user1.TableB,user1.TableA where
user1.TableB.log_num = user1.TableA.logger',
@dbuse='database1',
@attach_results='false',@width=88
delete from user1.TableA

Output for SQL Server 7.00.842 on Windows 2000 Server(2195) appears as below:

LabelA
----------
2477

columnA
------------------
A user can submit queries in the MDL Doc Mngr in the following fashion: *1*2*3* for the
description which returns the desired results. The Win Doc Mngr does not.

columnB
----------------
The following files have been added to installation. They will reside in the %falcon_s
dir%\win32app\system32 folder and be installed to the workstation's system fold
er :

Output for SQL Server 2000 8.00.534 (sp2) on Windows 2000 Server(2195) appears as below:

LabelA
-----------
2477
columnA

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-04-17 : 09:32:39

I'm guessing this truncated at 4,000 characters. You can repost here.

kedst1
Starting Member

2 Posts

Posted - 2002-04-22 : 17:03:39

The message displayed was truncated when I attempted to post it. What actually happens is that the header and data for Label A are displayed correctly. Then the label for column A is displayed, but the data is not displayed until a dozen or more lines of hyphens are displayed. The hyphens are part of the header formatting as displayed in my original post.

The label for Column B is then not displayed until a dozen more blank lines are displayed. This is then followed by another dozen or so lines of hyphens and the data for Column B is displayed.

Does anyone know what has changed between SQL Server 7 and 2000 that may cause this type of behavior?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources