So your goal is to only send one email per recepient ?

In that case, alter your cursor :

declare mail_merge cursor for select DISTINCT supervisor_email,email_body from mail_merge

easyest way is to use sql server profiler.

Create your trace with all filters (db) you want and script it.

Then launch it in a startup job or procedure.

Change your dbmail-query !

Declare @TheQuery varchar(1000)

Set @TheQuery = 'Select * from dbo.mail_merge where supervisor_email = ''' + @supervisor_email + ''' '

execute msdb.dbo.sp_send_dbmail

@profile_name = 'Scn',

@recipients = @supervisor_email,

@subject = 'SCN...

No, not using raiserror.

Other options ?

- alter the monitoring software

- write your own xp ( :sick: ) to log the message you want. :sick:

From Books Online 😉

If you specify only the last two digits of the year, values less than or equal to the last two digits of the value of the two...

there can be more than one child table for any parent table..

First of all I would start using the correct datatype to query.

Use a datetime variable to query your dates.

You can do that changing the functions inputparameters to a single date...

always try to create your tempdb objects outside of a transaction (locking on tempdb)

A parent row can have more than one child rows in a child table....

EdVassie (12/1/2008)

---

This topic was discussed a few times at PASS, and the people who author SQL Server and the most experienced people in the user community are clearly saying you...

are there child tables that act as parent table for other tables ?

skjoldtc (12/2/2008)

---

I have a question for the frequent posters? Do you spend you employer's time answering questions here or are you doing it on your own time. If on your...

did you perform post-migration maintenance ?

/ * To be executed after a db-restore from a lower version than sqlserver 2005 !

*

*DATA_PURITY

* Causes DBCC CHECKDB to check the...

That's why it is considered a nation wide sports (over here) to try to avoid the rules whenever you can ... 😀

Do...

Grant Fritchey (11/30/2008)

---

Well, it was a thrilling moment, I don't mind saying. I'll be picking up one of those integrated face sheild/helmet/ear protection things soon (read ASAP). First time in...