Good job I was sitting down, or I might have fallen down! 😛

Hi Pete,

In addition, if you're looking to expand on what data to hold, it may be useful to break out the file info from the database table (you may have...

If you haven't set that yourself, then this line from 2008 BOL will explain it:

"The SQL Server Native Client ODBC driver and SQL Server Native Client OLE DB Provider for...

Nngh.. "Select ALL that apply".

Must. Read. Question. Properly.

Thanks for the question bythe way! 🙂

Actually, of course I knew about a full backup and checkpoints in the log... What am I.. Why... - I'll get my coat.

GilaMonster (8/26/2009)

---

Used portion of data, yes. Used portion of log, no. Full backup backs just enough of the log up to ensure that the DB can be restored consistently. It's...

Generally the uncompressed backup size will be equivalent to the size of the used portion of the data and log files. When you restore, however, the full size of...

GSquared (8/19/2009)

---

The question doesn't actually ask what the author thinks.

I got it right, but only by trying to outthink the author.

None of the answers given were actually sequitur to the...

Dietmar Weickert (8/17/2009)

---

What's wrong with this...

Try chucking some dates into this and see if you get the result you are after, you may need to add to your serach patterns for all the different formats...

As above post, I'm in the UK and setting the default login language to "British English" will render the format "YYYY-MM-DD" useless unless actually specified with 120 in a convert...

I agree with the above post, integer is very specific, in fact forget the odd character, even select convert(int,'0.0') will not work. select convert(decimal(2,1),'0,.0') will give the error...

Fair enough! The code you wrote was wrong, the reason you...

Hi satishbhargav4u,

It is certainly a solution, as in it will work in place of the code that gives you an error. I...

LeChuck took them!!

:crazy:

..puts down phone and gets coat...