juniorDBA13 (10/28/2016)

---

I have reconfigured logshipping but my LSAlert job on the primary is still failing.

On the secondary the transaction log shipping status report is showing OK, logs are being copied...

You can try disabling database mail and then re-enabling it, that sometimes works:

EXEC sp_configure 'Database Mail XPs', 0

GO

RECONFIGURE

GO

EXEC sp_configure 'Database Mail XPs', 1

GO

RECONFIGURE

GO

Sue

Same as what I posted previously. Maybe try this instead -

How to Manage Remote Access to the Registry: https://support.microsoft.com/en-us/kb/314837

Sue

gary.rumble (10/27/2016)

---

I'm afraid I don't remember all of the steps I took. There were many failed attempts to get this working.

The MSA (Managed Service Account) was created on the...

I usually see them with apps that are using SqlDependency and service broker.

Sue

Eric have given you great answers already. I don't know if there is a list of something like what you might be looking for as it's a bit different for...

tcronin 95651 (10/26/2016)

---

This is actually all the shows up in the logs

The SQL Server Integration Services 11.0 service failed to start due to the following error:

The service did not...

Another option...

You can use the values clause to get min and max values across a row but YMMV. I've had case statements outperform it at times and other times it...

When you made the changes for the service accounts, where did you change the service accounts? In the services applet, Configuration Manager, or what? Based on the messages below, it...

Bron Tamulis (10/25/2016)

---

Okay - I need to accomplish the following:

1. Read SQL Table - if query returns results then send email with query results

2. After sending email - update the...

scarr030 (10/24/2016)

---

Hey All,

I've got a few jobs that are run via the Agent. I'm getting errors on plenty of the jobs that state the 'profile name is not valid'. I...

It's not clear what versions you are on but...did you check sp_configure values on both servers? I'd double check the query governor cost limit settings. Check run and config values....

That is weird. Maybe try a new download of the SP from MS and see if that makes a difference. That's about all I can think of - that the...

MelDBA (10/20/2016)

---

Hi All,

I have experienced a very bizarre issue which caused a big mess in my production environment.

There are a number of databases on one SQLServer instance. But 3 database...

pjl0808 (10/20/2016)

---

Hi there,

I'm hoping somebody can help me here. I'm having issues installing SP4 or SP3 on an SQL 2008 Enterprise edition installation. This SP4 is a download...