Click here to Skip to main content
14,383,854 members
   

Database

 
GeneralRe: Job runs 3 times longer Pin
digimanus14-Aug-18 4:01
memberdigimanus14-Aug-18 4:01 
GeneralRe: Job runs 3 times longer Pin
Eddy Vluggen14-Aug-18 4:08
mveEddy Vluggen14-Aug-18 4:08 
AnswerRe: Job runs 3 times longer Pin
Mycroft Holmes28-Jul-18 15:14
memberMycroft Holmes28-Jul-18 15:14 
Questionjoin query Pin
Member 1391987420-Jul-18 5:53
memberMember 1391987420-Jul-18 5:53 
GeneralRe: join query Pin
Richard MacCutchan20-Jul-18 6:13
protectorRichard MacCutchan20-Jul-18 6:13 
AnswerRe: join query Pin
Victor Nijegorodov20-Jul-18 8:59
memberVictor Nijegorodov20-Jul-18 8:59 
AnswerRe: join query Pin
Mycroft Holmes20-Jul-18 13:58
memberMycroft Holmes20-Jul-18 13:58 
QuestionProblem sending email to group Pin
Danpeking11-Jul-18 0:33
memberDanpeking11-Jul-18 0:33 
Hi I have a SQL Agent task which sends an email to all staff. The email is different because it sends it to a group which has "require that all senders are authenticated" ticked in their settings. This task works fine from one node in our availability group. I've copied the job to a secondary node and it says successful but no email is sent. We've investigated and can see a blocked email with the error: "Your message can't be delivered because delivery to this address is restricted".

I have restarted the SQL Agent service which didn't make any difference. The database mail looks to be configured in exactly the same way it is on the other node where it works fine. Any ideas why it is not authenticating properly please?

A reboot is an option but we'd rather not do this.
AnswerRe: Problem sending email to group Pin
jschell16-Jul-18 17:12
memberjschell16-Jul-18 17:12 
GeneralRe: Problem sending email to group Pin
Danpeking16-Jul-18 23:42
memberDanpeking16-Jul-18 23:42 
QuestionReport server moved from one server to another server Pin
VK1910-Jul-18 9:04
memberVK1910-Jul-18 9:04 
QuestionSSIS Best Practice Regarding Storage Pin
#realJSOP27-Jun-18 4:52
mve#realJSOP27-Jun-18 4:52 
AnswerRe: SSIS Best Practice Regarding Storage Pin
Jörgen Andersson2-Jul-18 22:16
protectorJörgen Andersson2-Jul-18 22:16 
AnswerRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen3-Jul-18 0:19
mveEddy Vluggen3-Jul-18 0:19 
GeneralRe: SSIS Best Practice Regarding Storage Pin
#realJSOP3-Jul-18 4:08
mve#realJSOP3-Jul-18 4:08 
GeneralRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen3-Jul-18 4:30
mveEddy Vluggen3-Jul-18 4:30 
GeneralRe: SSIS Best Practice Regarding Storage Pin
#realJSOP3-Jul-18 6:13
mve#realJSOP3-Jul-18 6:13 
GeneralRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen3-Jul-18 6:30
mveEddy Vluggen3-Jul-18 6:30 
GeneralRe: SSIS Best Practice Regarding Storage Pin
#realJSOP3-Jul-18 6:43
mve#realJSOP3-Jul-18 6:43 
GeneralRe: SSIS Best Practice Regarding Storage Pin
Eddy Vluggen3-Jul-18 9:43
mveEddy Vluggen3-Jul-18 9:43 
QuestionSSMS 2016 and SQL Server 2008R2 Pin
#realJSOP27-Jun-18 0:31
mve#realJSOP27-Jun-18 0:31 
AnswerRe: SSMS 2016 and SQL Server 2008R2 Pin
Eddy Vluggen27-Jun-18 0:50
mveEddy Vluggen27-Jun-18 0:50 
AnswerRe: SSMS 2016 and SQL Server 2008R2 Pin
Victor Nijegorodov27-Jun-18 2:07
memberVictor Nijegorodov27-Jun-18 2:07 
AnswerRe: SSMS 2016 and SQL Server 2008R2 Pin
Richard Deeming27-Jun-18 2:35
mveRichard Deeming27-Jun-18 2:35 
GeneralRe: SSMS 2016 and SQL Server 2008R2 Pin
#realJSOP27-Jun-18 3:46
mve#realJSOP27-Jun-18 3:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.