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 4 years, 2 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,...

Took a couple of days off to start potty training and get back online this morning to discover my employer has designated Juneteenth to be a company...

Took a couple of days off to start potty training and get back online this morning to discover my employer has designated Juneteenth to be a company holiday.

So,...

Took a couple of days off to start potty training and get back online this morning to discover my employer has designated Juneteenth to be a company holiday.

So, yay. People...

The U.S. Congress decided (wisely for once) that they wanted people to want to stay home without worrying about the bills. So they authorized an extra $600.00 per (I think)...

I don't know if I'm lucky or got over the "burnt out" long ago. I "lost" my daycare in September, which means that up until pandemic became a thing, KKC ...

So yesterday we got a bit of good/bad news...

Good, in that the wife has been called back to work and goes back on Tuesday.

Bad, in that the wife...

Here's the query.  There's not any understanding on how the the language works, index usage (or lack of usage), and what these things do.

It works in dev, why is...

Why can a person not understand that when you write a query against dev that has 6 rows per table, and the query does 3 table scans, it will...