Hi,

Thanks a lot for the detailed reply. I totally take your point that a full restore (with DBCC CHECKDB) would be the only way to be absolutely sure that the...

Hi HanShi,

Thanks a lot for your perspective on this. It reassuring that the copying process is not really an issue.

Dave

Thanks very much for the reply Han Shi. It is interesting what you say about COPY command's internal checks on the data. I'm using ROBOCOPY and hopefully the level of...

Nice question, thanks Ron. I went for case insensitive, but wasn't entirely sure that was the way to go.

Thanks. Good question.

+1, except I...

Glad it helped Chris. Always best to check the credentials aye..

Hi Chris,

I think you can do this over the internet if you have an access code.

This article seems helpful http://www.ehow.com/how_5635234_check-microsoft-certification.html

Nice question thanks. The fact that type varchar(max) can not be used on indexed fields was new to me. A fact that this question has illuminated.

Thanks for the clarification

Nice question and quite comical. Fluked it really as I didn't note the bit in BOL "between 50,001 and 2,147,483,647" for the @msgnum. Thanks.

Nice question thanks. I've learnt something new, that SELECT INTO does not transfer the properties of a computed column to the target table.

Nice question thanks Bill, and thanks to Hugo for the extra information on SUBSTRING.

Nice question, thanks. It made me think - I better rest now ...... 😉

I was employed as a Data Analyst in health care. The organization used a Firebird based system and I found myself starting to code SQL to obtain data for analysis....