what is the collation and data type of the field storing the current date?

The topic of Derek Jeter comes up a lot with a coworker of mine. I think he's a pretty decent player. He holds a few club records and a few...

hey hey hey!

Enough ganging up on me or I'm tellin' Steve!

So when you right click the job and start it it does nothing.

When you right click the job and check the job history, what does it say is the result...

Perhaps you can run the backup code by itself, outside the scope of the job.

BACKUP DATABASE [database] TO DISK = '<path>'

If this works, it's not a backup issue but a...

What is the exact error you are getting. If the backup fails, it's gotta tell you why.

First way I think of is using a combination of NULLIF and ISNULL

SELECT

ID,

ISNULL(NULLIF(val,''),0) AS val,

ISNULL(NULLIF(ser,''),0) AS ser,

ISNULL(NULLIF(sa,''),0) AS sa

FROM @test1

TDE enabled databases can't be compressed. Although this shouldn't stop a backup from running, it is the only thing I can think of off the bat.

Are you compressing them?

Edit: I...

Steve Jones - SSC Editor (7/30/2012)

---

calvo (7/30/2012)

---

Oh man! It only took a double ejection, extra innings, and lady luck to pull it off but Boston took 2 of 3 in...

Oh man! It only took a double ejection, extra innings, and lady luck to pull it off but Boston took 2 of 3 in NY!

That's great news, it means...

I too like Ichiro, never hear bad things about him. Kinda weird though, the whole thing happening in Seattle. One day he's 51, next day he's 31.

Wow. If Lester hit...

A couple things, there is no date for 1/28/2011 as you specify in your expected result so I'm assuming that was a typo on the insert statement. I see another...

Please do not double post, it's not good.

All replies here

Is there an open transaction on which these processes are waiting?

select @@trancount

Literally? Yeah, I could see that ending life on earth...

/rimshot