Good drills, thanks for the tips!

SQL 2000, DBCC CHECKALLOC & DBCC CHECKCATALOG runs ok

Mis-read the 'Perform' in the question and missed the right choice.

Excellent, works as advertised!

Thanks for your time and effort.

May all your hangovers be swiftly cured...

Glen Parker 🙂

Hi Lowell, thanks for your input, should have been clearer in the first instance, script as follows;

INSERT INTO [tbl_765_documents_temp](ID, [765_id], [765_Document], Document_title, filename, filesize, contenttype, filedata, date_attached)

SELECT ID, [765_id],...

Good article, well presented, will probably implement some of it.

Thanks!

Seemed straight forward to me.

Can't believe so many got it wrong!

Not sure if it was a browser issue but couldn't copy the script to paste into Query Analyser, anyone else have that problem?

I used to retain the last 2 Full AND Transaction Log backups pending verification of a RESTORE into a shadow DB however, after listening to sob stories from the IT...

Never seen this wildcard till now, thanks for the tip, was worth getting it wrong

Like all 2000 users, I voted for option 'C' and got it 'wrong'

Would it be possible for future QotD to be validated in 2000, 2005 & 2008 before submission.

As a...

Maybe I should do it more often but I restore into a shadow database once a month and access a selection of known changes, so far so good but better...

Given that SQL is logic based, its a shame that the result was so ambiguous...

Like most, I got it wrong too however given the explanation, surely the data capture is...

Morning Lynn

Thank you for the script, worked first time:)

I like the simplicity and effectiveness of the 'nested loop' and wonder how I never realised the solution for myself. I...