After all these years, I've found a palatable solution. The design pattern involves these steps:

1. Create and start an Extended Events Session: it will capture sqlserver.error_reported events, filtered primarily by...

• This reply was modified 5 years, 8 months ago by  Dave Mason.
• This reply was modified 3 months, 2 weeks ago by  Dave Mason.

Mine was a rhetorical question....

Does execution order of the three stored procs matter? I've not been able to force an execution order when there are multiple SPs involved.

SQL Server Event Handling: Startup

I decided to run a "check" at startup that would try to determine if the SQL instance had been cloned.

TLDR: Hard-code the SQL host machine name and...

I'd like to know the answer to this one, too. Anyone?

I can restore the db, set it to SINGLE_USER mode, and then run DBCC CHECKDB. But there are still allocation/consistency errors in...

I restored the May 10th backup. DBCC CHECKDB still fails. I double-checked the SQL Server Agent job history. The May 10th job that created the full backup...

Thanks Jack and Gail. On May 10th and May 17th, I took full backups. DBCC CHECKDB completed with no errors on the 10th. The logical consistency error...

Thanks for your input, everyone. I wish I had worded my original post a bit differently. It's kinda silly to proclaim either option is right or wrong. ...

paul.knibbs (4/25/2014)

---

Only someone who has domain admin access should be able to edit the users in the AD group, and if someone with that level of access wanted access to...

Tony Sweet (4/24/2014)

---

Think about it - if the other sysadmin leaves the company you now need to remove that from 50-100 servers. While this is easy to do with...

I've decided Option 2 is the way to go for me. I finally found some "best practices" info, although it's related to PCI DSS compliance. It's a great read with...

Here's a pure t-sql solution to my problem:PJ on Development: Retrieve Error Message

So far, I like the new feature.

FYI,

I went back to some of my posts to click the "Mark as solution" button (where appropriate). For this post, I saw the...

Geez, there really isn't much info out there that is directly related to my issue. I did stumble upon this MS support article about the full-text indexing time-out value:...