I like the option presented by MM.

Just throwing out another option. At a previous employer, we used a posh script to authenticate and launch ssms. If the creds were...

retriever

dwain.c (3/26/2015)

---

ChrisM@Work (3/26/2015)

---

Where’s a plan showing huge Estimated Operator Costs when you need one? Have a look at the estimated plan for this conditional query i.e. the IF as well...

sipas (3/26/2015)

---

It usually makes them think 'if he...

blooded

pursuit

Ed Wagner (3/24/2015)

---

SQLRNNR (3/24/2015)

---

Brandie Tarvin (3/23/2015)

---

Eirikur Eiriksson (3/23/2015)

---

GilaMonster (3/23/2015)

---

If you find it, I think this query can only be done if the WITH...

Inside your query to be executed you need to change the database in order to change the results. In other words, a use dbname needs to be employed.

Buahaha. Thanks for the idea. 😉

Anandita Sharma (3/24/2015)

---

I am running a split disk backup such as:

BACKUP DATABASE [At] TO

DISK = N'O:\sql_bak\At_full1.bak',

DISK = N'M:\sql_bak\At_full2.bak',

DISK = N'L:\sql_bak\At_full3.bak' WITH NOFORMAT,

INIT,

NAME =...

Brandie Tarvin (3/23/2015)

---

Eirikur Eiriksson (3/23/2015)

---

GilaMonster (3/23/2015)

---

If you find it, I think this query can only be done if the WITH (CrystalBall) join hint...

You would have to create an audit to capture this kind of data. It is not maintained otherwise.

Funny. After talking to some friends today after their travel woes.

After boarding the plane, everybody had...

spaghettidba (3/20/2015)

---

Alvin Ramard (3/20/2015)

---

Koen Verbeeck (3/20/2015)

---

Alvin Ramard (3/20/2015)

---

SQLRNNR (3/20/2015)

---

Brandie Tarvin (3/20/2015)

---

BWFC (3/20/2015)

---

Brandie Tarvin (3/20/2015)

---

I'm trying to figure out if this one is real or not. Anyone seen this? (click the...

Brandie Tarvin (3/20/2015)

---

Wow. Just...