And you may guess - I don't like to login into servers to verify that everything is working. I prefer to look at things which are NOT working.

"Mr. Corleone...

A few years ago, when I was getting ready for maternity leave, we hired a contractor to fill my position. While I was training them, I showed them how I...

OH GOOD GRIEF!

My problem was caused by a typo in the NAS share destination (a File System task further down in the ForEach Loop) not in the actual ForEach Loop.

Nevermind...

Don't want to turn this political, but thinking of you guys on the left side of the pond. I just finished re-watching the excellent West Wing two days ago...

My employer made the decision back in September to not go back into the office until end of July at the earliest. Interestingly, they had already been slowly working to...

Allstate made the decision months ago that we're WFH until the end of July. Because they were already moving in the direction of "all IT people should work from home...

Regarding the accidental DBA, has no one seriously running into the anti-virus scanning issue? The more he posts, the more I'm convinced one of his servers is scanning the db...

Silly question... Have you checked the anti-virus?

I've seen major issues multiple times when the anti-virus exclusion list gets changed (file types removed or folders removed) and suddenly the thing we...

Now, perhaps someone can help me. I have a database with fields, and one field has a value of "eggs, bacon, sausage", how do I get this to have...

So I've managed to unwind most of this build. Unfortunately, I was left 2 credentials created with an asymmetric key that are orphaned (not sure how I did that). They...

• This reply was modified 5 years, 1 months ago by Brandie Tarvin. Reason: Asymmetric really should have a K in there somewhere given how many times I keep adding it in. Sigh

For those familiar with TDE, I could use a hand over here: https://www.sqlservercentral.com/forums/topic/tde-drama

I did something stupid. I'm just not sure how to unwind it.

I figured it out finally. Had to grant execute permissions to that proc in master. The error was misleading.

If you want better answers to your questions, you might want to consider rephrasing your topic titles and initial posts. Reframing this situation might have gotten your answer faster and...

Soooooo… This is a weird one.

My coworker just set up a SQL Server (2019) and can't connect to it without the port number. IE, SeverName\InstanceName,1433. Oddly enough, I can connect...

First, I agree with Jeff on how cutting out the middle man can cause all sorts of legal problems and also get you (or the people handing out permissions) fired.

Second,...