As Gianluca has shown, one way to do this is to split @P1, because it is no use in it's current format as a parameter.

Col1 would have to have...

Backup WITH CHECKSUMS can make the backup file itself more reliable - http://msdn.microsoft.com/en-us/library/ms189587.aspx.

However, the best way to check backups are ok is to restore the data elsewhere and run DBCC...

The backup option 'WITH CONTINUE_AFTER_ERROR' may work - it all depends upon the corruption.

Why do you want to backup a corrupt database?

I particularly like the fact that a QOTD was verified by several people before publication.

Wonderful, thank you very much for your time and assistance.

I had just found the section within my copy of "Programming Microsoft SQL Server 2008", and although I could see it...

Paul Randal wrote a technical article that is worth reading, showing the various ways to enable it and the performance issues (and other areas too):

http://msdn.microsoft.com/en-us/library/cc949109(v=sql.100).aspx

I think it depends on the presentation you go to and the skill of...

So the real answer is that SQL Server mantra - 'It Depends'!

Hugo Kornelis (2/22/2012)

---

Based on a vague recollection, I answered that you can set it on the model database, but it won't affect new databases. I then found I apparently was...

ganeshkumar005 (2/21/2012)

---

I have a requirement here. There is a string '0005 ganeshkumar A999'. I want the last four character 'A999' as output where it is not necessarily a four charactes...

That is an inordinate amount of work in order to retrieve all rows back quickly. To repeat Gail's question - why do...

First of all - NOLOCK should not be considered as a 'go faster' switch. That's a misconception that abounds the forums for no good reason - http://itknowledgeexchange.techtarget.com/sql-server/what-does-with-nolock-actually-mean/. It avoids locks...

Roy Ernest (2/9/2012)

---

Lynn Pettis (2/7/2012)

---

Now that it is officially posted on facebook, I can start telling everyone.

Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was...

The closest equivalent to that Oracle option is probably Bulk Logged Recovery - see http://msdn.microsoft.com/en-us/library/ms189275.aspx and http://msdn.microsoft.com/en-us/library/ms191244.aspx.

You have a couple of '=' missing - double-click on the error message and it will take you to the appropriate line.

@Surname '',

@Suffix '',