Hugo Kornelis (6/25/2012)

---

When I answered the question, I *knew* I was taking a gamble on the intended interpretation.

...... so I was looking for an answer option "true for temp tables;...

tommyh (6/19/2012)

---

If one wants be really picky "Depends on File System" is actually the right answer.

You can install 2012 on FAT32 and that have a limit to 4GB/file. The...

I agree

Absolutely agree !!

Christian Buettner-167247 (8/23/2011)

---

elbedata (8/23/2011)

---

It returns "that" when I test on SQL Server 2008, but I thought it should return "this"...

Has this changed in later SQL versions? I am pretty sure...

Spot on Simone - there should have been two answers!

Doing this post to get my point back

Try doing a DBA job within the financially constrained defence sector.

Oh for the luxury :hehe: of being able to have "a dedicated SQL server with highest SQL version in...

Back in the halcyon days of DOS :hehe: etc., CHAR(13) was the carriage return control character - and did just that, i.e. returned the carriage to the start of the...

Thanks Ben.

Just to confirm the finer detail:

Tickets are pulled from the book at random, numbered 1-999, but in addition to the big number there is a 6 character alphanumeric book...

As I see it, there are three main objectives to be met:

- Each backup should have its own unique password.

- The method of password generation must not be...

I guessed (wrongly?) that the INSERT INTO would fail.

However, testing your code on a UK system showed that I was indeed correct and the statement fails due to implicit conversion...