>
> CREATE TRIGGER ... ON ... AFTER INSERT AS
> EXEC xp_sendmail {[@recipients =] 'recipients [;...n]'}
> [,[@message =] 'message']
> [,[@query =] 'query']
> [,[@attachments =] 'attachments [;...n]']
> [,[@copy_recipients =] 'copy_recipients [;...n]'
> [,[@blind_copy_recipients =] 'blind_copy_recipients
> [;...n]'
> [,[@subject =] 'subject']
> [,[@type =] 'type']
> [,[@attach_results =] 'attach_value']
> [,[@no_output =] 'output_value']
> [,[@no_header =] 'header_value']
> [,[@width =] width]
> [,[@separator =] 'separator']
> [,[@echo_error =] 'echo_value']
> [,[@set_user =] 'user']
> [,[@dbuse =] 'database'])
>
> So etwas definiert man im Enterprise Manager oder im Query Analyzer.
>
> Freundliche Gr��e
> Joachim van de Bruck
Hallo,
Also ich habe Probleme damit...
Fehler:
[Microsoft][ODBC SQL Server Driver]Syntax error or access violation
Abfrage:
(Im Query Analizer...)
CREATE TRIGGER [infomail] ON [veranstalter] FOR INSERT AS
EXEC xp_sendmail {@recipients ="[EMAIL PROTECTED]"
,@message ="Neue Eintragung"
,@query ="Select * from veranstalter"
,@subject ="Neue Eintragung"
,@type = NULL
,@attach_results =NULL
,@echo_error = true
,@set_user ="***"
,@dbuse = "Datenbankname"}
Was kann das Problem sein?
Gru� Mansur
| [aspdedatabase] als [email protected] subscribed
| http://www.aspgerman.com/archiv/aspdedatabase/ = Listenarchiv
| Sie k�nnen sich unter folgender URL an- und abmelden:
| http://www.aspgerman.com/aspgerman/listen/anmelden/aspdedatabase.asp
