The explanation excludes the DISTINCT keyword, which might be confusing if you didn't already know the correct answer.

Nice to see that 4% of respondents chose the "Don't choose this" option. 🙂

Have you tried setting DelayValidation to False on the task?

Thankfully, it's been over a decade since I set up a fax server, and it was a different product, whose name escapes me now. But back then, we had...

I would separate the inactive flag from the other user roles. A user could be a TVI AND inactive, correct? Perhaps you may need to know what type...

How about something like this? I haven't tested it, but it might be a good place to start.

DECLARE @tableName VARCHAR(256) = 'dev'

DECLARE @serverName NVARCHAR(250)

DECLARE @sqlQry NVARCHAR(2000) = N'''EXEC sp_msforeachdb...

Mike Hays (11/25/2014)

---

Maybe its me. Once I had BASIC loaded on my Altair 8800, I can not seem to remember anything before that (like my wedding, children being born,...

I could see why so many people answered 1/1/1900, based on the phrasing of the question. If you assign 0 to a datetime, that's the date you'll get in...

Grant Fritchey (11/14/2014)

---

Gotta agree. Without an edition being stated, the answers change. Just saying SQL Server, I would assume the full product, then the minimum is 1gb, but the recommended...

Koen Verbeeck (11/6/2014)

---

I didn't notice at first why the import would fail. After all, 150 characters fit perfectly in a 200 character-wide column.

Then I remember the default for the flat...