Hello,

I am seeing the same issue. I checked the database configuration and it seems OK, but perhaps someone else can post more info on why this happens and how to...

Thanks, Frederico. This was indeed ultimately a permissions issue.

-- webrunner

Hello,

You can also run the query here for a general sense of what SQL Server is waiting on:

SQL Server Wait Statistics (or please tell me where it hurts…)

https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

HTH.

-- webrunner

"I walked outside to take the call during a break and was told I wasn't responding quick enough to the call. The emergency? A test of how quickly I'd respond...

• This reply was modified 2 years, 11 months ago by webrunner.

Jeff, at the risk of introducing more adages into this thread, your most recent reply reminds me of another I heard once: "If you don't have time to do it...

I once read about a term in economics that was coined for this kind of decision making: satisficing.

Satisficing is a decision-making process in which an individual makes a choice that...

Hi Ed,

Thanks. The even types are:

mydb1: event types 4 and 2

mydb2: event type 3

According to the MS documentation, those mean:

2 = Bad checksum.

3 = Torn page.

4 = Restored (page was...

Thanks Ed, that is an excellent reminder. I too often focus on doing what is asked of me. Sometimes the answer has to be "That is not possible," or "That...

Thanks, Scott. This is what I came up with. I decided not to use SET IDENTITY_INSERT dbo.sysjobhistory ON since they are just interested in having access to old history, not...

• This reply was modified 3 years, 2 months ago by webrunner.

Thanks so much, Scott. That is extremely helpful information. Much appreciated.

-- webrunner

@edwardwill "The correct answer should be "Create Certificate". There is no LOAD CERTIFICATE Command."

That's what I thought!

-- webrunner

Thanks for this question, Steve. Especially because it explains another one of the generic errors that get returned from SQL Server, such as string or binary truncation etc.

-- webrunner

Thanks for this helpful review of the AVG() T-SQL function!

I'd just like to call attention to the few minor typos in the article - just helpful feedback. For example

"all female...

Gotcha, Jeff, thanks for the disclaimer. At the very least I can use the info you provided to rule in or rule out the issue. Much appreciated.

-- webrunner

Thanks so much, Jeff, I will review those articles.

Thanks again!

-- webrunner