We're back filling 2 people who retired.

Allstate is looking for mid to senior level DBAs for a remote U.S. hours job. Must have good experience with 2 RDMSs. Ping me if you want more info.

Not sure...

It will not. I have tried subquerys and the server name still gets added to the top SELECT list, ruining my totals.

It appears I will have to query from another...

The solution is DENY CONNECT TO <ThisLogin>;

I just had to remove "SQL" from the code.

What can I say? I was having an off day.

Oh, goodness. I'm doing research for this issue for my company (Thank you so much for the article, Steve!) and discovered a "nasty."

Per SQLFingers:

Local connections

Connections from the SQL Server host...

Yikes. That's rough. You have my sympathies.

They won't amputate the leg? That's the usual treatment.

Both dogs and cats do quite well with 3 legs. That's why vets started putting the vaccines in the rear legs, to...

True true.

Changing the subject... Last week was fun. One of my cats ended up with a large bump suddenly appearing on her leg. As I've been through this before, I had...

Neil,

You know what I've heard a lot of recently? CISSP certified security people are in high demand right now.

Granted, it's a hard cert to study for and get. You have...

Nevermind. I needed to leave out the SQL keyword.

Ha yeah I was reluctant to test it out.  Sorry for the syntax issues.  Originally I had a table CREATE statement but then switched to SELECT INTO because that's...

• This reply was modified 5 months, 1 weeks ago by Brandie Tarvin.

This isn't code, but you could also put a max size on tempdb so you don't need to have as much use to run out of space if you...

21 years is a good run. It's a shame about the redundancy right before the holiday season. I don't know if my company has openings for your skill set or...

Bah, humbug. It's erroring out.

FYI: Your "into #t" is in the wrong spot.

And I need to figure out the below error. I think my sandbox server is a version lower...

• This reply was modified 5 months, 2 weeks ago by Brandie Tarvin.