Ed Wagner (6/10/2016)

---

WayneS (6/10/2016)

---

Phil Parkin (6/8/2016)

---

And why not ask them to make it idempotent while you're at it:

IF COL_LENGTH('dbo.mytable', 'col1') IS NULL

BEGIN

...

Steve Jones - SSC Editor (6/10/2016)

---

Brandie Tarvin (6/10/2016)

---

[

We're currently using a data warehouse for this. The ETL isn't too nasty, but it took us forever to figure out the best...

Steve Jones - SSC Editor (6/10/2016)

---

Steve Thompson-454462 (6/10/2016)

---

Brandie Tarvin (6/10/2016)

Thanks for the reply.

I wonder... Our reporting team has a database where they essentially flatten all our data into giant tables...

Steve Thompson-454462 (6/10/2016)

---

Brandie Tarvin (6/9/2016)

---

Y.B. (6/9/2016)

---

So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?

I realize...

And some of us thought the Microsoft certification process was debt-heavy. Glad none of us have to do this.

ThomasRushton (6/10/2016)

---

Ed Wagner (6/10/2016)

---

I thought so too. They can be a little...

ThomasRushton (6/10/2016)

---

Brandie Tarvin (6/10/2016)

---

I'm going to say Yes only because DB Mail is...

I'm going to say Yes only because DB Mail is incredibly confusing the...

naveenareddy.dba (6/9/2016)

---

Hi

i tried this but its giving the error like this

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 62

The configuration option 'Database Mail XPs' does not exist, or it...

naveenareddy.dba (6/10/2016)

---

Hi

yes it is the sql server 2012.

i have done all the things still mail is not sending the status is failed its saying.

i uploaded the screen... please suggest the...

Y.B. (6/9/2016)

---

So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?

I realize that there are good...

Ed Wagner (6/8/2016)

---

Lynn Pettis (6/8/2016)

---

Mention Dynamic SQL and suddenly that is THE solution for the immediate problem, but what problems may it cause down the road?

Won't be surprised if we...

Ahha! A clue.

The SQL Server Agent Service is running under an application domain account instead of our usual SQL Server Agent Service account for some reason. So I am now...

<headdesk>

User asks me to move this bit of code into QA:

ALTER TABLE MyTable

ADD Col1 INT,

Col2 INT

GO

I push back and say "Please add your statement terminator" because...

The testers already had those...