Thanks for the reply. 

how to monitor DBmail, I mean in terms of audit if the DBmail is stopped.

bump

any help ?

LOL

Thanks Lynn it worked!

Hi Palotaiarpad,

the date logic is used in SQL agent t-sql code which runs @ 6AM in morning and exports a CVS file.

when the job runs at 6AM it should...

Awesome thank you!

Hi Palotaiarpad,

Thanks for all your help.

how does it work for below statement from 4PM to next day 6AM

ANDt.StartExport BETWEEN CAST('2015-07-06 16:00:00.000' AS DATETIME) AND CAST('2015-07-07 06:00:00.000' AS DATETIME)

Thanks for all your replies

1) SQL 2012

2) To a developer, look at the permissions at database level.

any help please.

Thanks GilaMonster..!

HELP Please..!

Merge statement is compatible with Peer to Peer replication?

Help please..!

without backup and restore peer-2-peer replication can be successful?

Merge statement is compatible with Peer to Peer replication?

Thanks for your reply.

when we run the MERGE on SQL server 2012 it runs fine.

But when it runs on SQL server 2008R2, the queue reader agent fails with...