Luis Cazares (6/7/2016)

---

Jeff Moden (6/7/2016)

---

Luis Cazares (6/7/2016)

---

Try this:

SELECT sys.fn_get_folder(path, 1)

Absolutely the correct answer! 😛 Well, except for the Hungarian notation used. :hehe:

That's the MS standard. 😀

WayneS (6/6/2016)

---

PRO TIP:

If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.

HappyGeek (6/6/2016)

---

djj (6/6/2016)

---

Ed Wagner (6/6/2016)

---

Revenant (6/6/2016)

---

Ed Wagner (6/6/2016)

---

djj (6/6/2016)

---

Ed Wagner (6/6/2016)

---

Grumpy DBA (6/6/2016)

---

djj (6/6/2016)

---

Skywalker

Moonraker

Bond

James Bond

Sean Connery

Scotland

Kilt

Sporran

Tartan

Revenant (6/6/2016)

---

Ed Wagner (6/6/2016)

---

djj (6/6/2016)

---

Ed Wagner (6/6/2016)

---

Grumpy DBA (6/6/2016)

---

djj (6/6/2016)

---

Skywalker

Moonraker

Bond

James Bond

Sean Connery

Scotland

djj (6/6/2016)

---

Ed Wagner (6/6/2016)

---

Grumpy DBA (6/6/2016)

---

djj (6/6/2016)

---

Skywalker

Moonraker

Bond

James Bond

Grumpy DBA (6/6/2016)

---

djj (6/6/2016)

---

Skywalker

Moonraker

eccentricDBA (6/3/2016)

---

Luis Cazares (6/3/2016)

---

Ed Wagner (6/3/2016)

---

Grumpy DBA (6/3/2016)

---

djj (6/3/2016)

---

crookj (6/3/2016)

---

Manic Star (6/3/2016)

---

Burning Man

Running Man (Stephen King as Bachman)

Running Bear

Sleeping Bear (Dunes)

M-22

T-1000

THX 1138

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

---

SSMS is decoupled from SQL. You need to install that separately.

Grumpy DBA (6/3/2016)

---

djj (6/3/2016)

---

crookj (6/3/2016)

---

Manic Star (6/3/2016)

---

Burning Man

Running Man (Stephen King as Bachman)

Running Bear

Sleeping Bear (Dunes)

Ray K (6/3/2016)

---

Luis Cazares (6/3/2016)

---

Ed Wagner (6/3/2016)

---

djj (6/3/2016)

---

Beer

Friday

Weekend

Working for the...

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

---

SSMS is decoupled from SQL. You need to install that separately.