Congrats, Gail.

I guess the next thing is for your number of posts to surpass the number of posts in the thread. 😎

And for those with no experience of 2005 who noticed...

I mostly used the built-in roles, but because using only teh built-in roles would sometimes mean either splitting data I want to have in one database over two (or more)...

Because a select...

Definitely a good question.

At first I thought is was easy. Then I thought maybe it wasn't - could it be possible that in the case of a clustered index...

Ed Wagner (12/2/2013)

---

I'm glad you did the strikeout with English and...

Direct

I agree with everyone else who said the only safe way to do it is with an ORDER BY clause.

As for unsafe methods, whichreally ought not to be used...

Hany Helmy (12/1/2013)

---

[The Friday after Thanksgiving is known as Black Friday in the US].

Ok, that was something totally new for me, editors of SSC should know that this kind of...

Hugo Kornelis (12/1/2013)

---

But [a], , and [cde] are all wildcard patterns - a search pattern that combines wildcard characters and normal characters to define the set of strings that should...

Steve Jones - SSC Editor (11/30/2013)

---

I still don't agree with you. I asked:

"which of the following wildcard characters"

To me that implies that [] is a wildcard set of characters. I...

Puke

I was in IT for over 40 years, and remained a pretty much a generalist throughout.

I think overspecialisation has caused problems in our industry; probably a fairly high ratio...

Nice easy one.

But isn't the right answer is "It depends? (On whether you are using Access or SQL Server) :hehe:

And does the agent account (or the service account if you haven't set up an agent account fr xp_cmdshell) have write permissions for that file and path?