We've done something like this in the past and it gets cumbersome, but it accomplishes what you want. The trick is the breaking/merging of phone numbers. Sometimes you'll have two...

There is no good comparison I know of because they are really different products. You cannot buy SQL Server 2000 anymore and for new servers, I'm not sure it makes...

Haven't used either in years and I just finished the 431, 441, 443, 444 series.

Taking a test is a skill and for the 441/443 exams, there are case studies you...

You need to get the eval or copy of SQL 2005 and spend time working with it. The prep guides on the MS site for each exam give you an...

There isn't an easy way I can think of. You could use an Active X task in a parent package to modify the current package and add tasks, but I...

Kevin has a great analysis. Go with that.

Raiserror can log them. Look at the options in BOL.

I wouldn't expect issues either. If you're serving pages on the web, it's a bad practice to have SQL on the same box as IIS for security reasons, but not...

Allocate more space to the log file. I'd run it up to 2GB or so. It doesn't hurt you to reserve the space and preventing growths during busy transactions is...

The SQL_Oracle is right. There is no answer.

The default works well, but it depends. The log grows because of changes in your data. If you have mostly static data, like...

I passed last week and this was definitely a hard exam. Broad coverage of lots of topics, so be sure you know the product pretty well. Also the simulation sections...

I think it's probably irrelevant, but you definitely need to keep track of it. I have had to pull old data for legal reasons, though drop it in it's own...

Failure of a project is definitely something I think you can measure and a few people have given some nice criteria.

However personal success or failure is something different and something...

select a.item, a.date

from MyTable a

where a.date = ( select max(b.date)

...

If you just need schema, then I'd just script out the database. All tables, views, procs, users, security, etc. Basically check everything in the script box.