EXEC msdb..sp_send_dbmail 

@recipients = 'status@mydomain.com',
@subject = 'yeahaaaaaaaaa ';			
--@body = @message;
END

quote:

---

sp_send_dbmail [ [ @profile_name = ] 'profile_name' ]
[ , [ @recipients = ] 'recipients [ ; ...n ]' ]
[ , [ @copy_recipients = ] 'copy_recipient [ ; ...n ]' ]
[ , [ @blind_copy_recipients = ] 'blind_copy_recipient [ ; ...n ]' ]
[ , [ @subject = ] 'subject' ]
[ , [ @body = ] 'body' ]
[ , [ @body_format = ] 'body_format' ]
[ , [ @importance = ] 'importance' ]
[ , [ @sensitivity = ] 'sensitivity' ]
[ , [ @file_attachments = ] 'attachment [ ; ...n ]' ]
[ , [ @query = ] 'query' ]
[ , [ @execute_query_database = ] 'execute_query_database' ]
[ , [ @attach_query_result_as_file = ] attach_query_result_as_file ]
[ , [ @query_attachment_filename = ] query_attachment_filename ]
[ , [ @query_result_header = ] query_result_header ]
[ , [ @query_result_width = ] query_result_width ]
[ , [ @query_result_separator = ] 'query_result_separator' ]
[ , [ @exclude_query_output = ] exclude_query_output ]
[ , [ @append_query_error = ] append_query_error ]
[ , [ @query_no_truncate = ] query_no_truncate ]
[ , [ @mailitem_id = ] mailitem_id ] [ OUTPUT ]

---

ALTER TRIGGER [dbo].[basisdata]
ON [dbo].[YKUN0015]
FOR INSERT,UPDATE
AS
SET NOCOUNT ON
@query nvarchar(max)
@subject nvarchar(255)
@attach_query_result_as_file bit

EXEC msdb..sp_send_dbmail 
@recipients = 'status@mydomain.com',
@subject = 'yeahaaaaaaaaa',
@query = 'Select * from basisdata where nummer = 100710',
@attach_query_result_as_file = 1;

quote:

---

Originally posted by pootle_flump

I would recommend you don't do any of this in a trigger. Triggers act as part of transactions. Emails & writing files should not be part of transactions, they should be asynchronous....

---

quote:

---

Originally posted by visakh16

for creating the file with query result use bcp

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/bcp-export-data-to-text-file.aspx

---

quote:

---

Originally posted by pyromelana

that is my problem, isn't it? so, next time pls help or do not write something that is neither helpful nor a solution

thx

---

quote:

---

Originally posted by pootle_flump

quote:

---

Originally posted by pyromelana

that is my problem, isn't it? so, next time pls help or do not write something that is neither helpful nor a solution

thx

---

Public forum. Perhaps you should employ a competent professional to correct your design flaws if you want to keep things out of the public domain?
kthxbai

---

quote:

---

Originally posted by pyromelana

quote:

---

Originally posted by visakh16

for creating the file with query result use bcp

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/bcp-export-data-to-text-file.aspx

---

can I create a procdure in a trigger? can you tell me, why Microsoft added the possibility to attach_query_as_file like readable in the manual? what is bcp?

---

quote:

---

Originally posted by pyromelana

and to post 'do and don't' is not a goob behavior in a forum, recommendations are welcome but only together with a helping hand

---

quote:

---

Originally posted by visakh16
why do you need to create a procedure in a trigger? can i ask what your exact requirement is?

---

quote:

---

Here is a simple method of exporting all the data from SQL Server table to a Text File

CREATE Procedure BCP_Text_File
(
@table varchar(100),
@FileName varchar(100)
)
as
If exists(Select * from information_Schema.tables where table_name=@table)
Begin
Declare @str varchar(1000)
set @str='Exec Master..xp_Cmdshell ''bcp "Select * from '+db_name()+'..'+@table+'" queryout "'+@FileName+'" -c'''
Exec(@str)
end
else
Select 'The table '+@table+' does not exist in the database'




Execute this procedure by giving Table Name and the File Name

EXEC BCP_Text_File 'Employee','C:\emp.txt'

Now all the data from Employee table will be exported to the text file which will be located at C:\emp.txt

---

quote:

---

Originally posted by visakh16

what do you mean by special case? is it the normal DML operations?

---