No problem. Glad to help.

Ed Wagner (11/22/2015)

---

Jeff Moden (11/22/2015)

---

Lowell (11/6/2015)

---

i seem to remember that xp_cmdshell is limited to a single set of double quotes, right?

so "\path with spaces\oldname" "\path with spacesewname" might return an...

Jeff Moden (11/22/2015)

---

No. ...

I think the spam bomb went off again today.

There are certainly ways to save money in IT. As the article pointed out, however, not taking care of your people is foolish because good people are worth more...

One approach you could use is to write a procedure to query the system view you want and return the data. When you create it, do it WITH EXECUTE...

I think HR being the first interview is simply to get the housekeeping questions out of the way. These are things like determining if the person is employable, if...

Want

Steve Jones - SSC Editor (11/20/2015)

---

Xavon (11/20/2015)

---

Of course the correct answer is it throws an error, because nobody has a table named 'MyTable'. And if they do, the 'test'...

Learning

Brandie isn't the only one to experience these seemingly-random quirks with logins. There are times when a user mapped to a login just doesn't work, but I haven't been...

Brandie Tarvin (11/20/2015)

---

jasona.work (11/20/2015)

---

So, it's looking like we're going to get our first snow of the year tomorrow night or so...

3-6", and it looks like they're predicting it'll be that...

I never heard of WORK before, so I learned something new today. That's always a good way to end the week. Thanks.

An interesting question. I guess I don't see where any of it is in the execution plan itself.

Target